Power Query data model, time summed showing all the same

[greegan]

Hello,
I am new to data models but the relationship doesn't seem to be an issue, I'm summing time in my columns and each columns appears to have the same issue.
The time format isn't an issue. What I'm having a strange problem with is that the summed amount is the same for the whole column and this is happening with each column where I have the time summed for each agent of my call center.
Is this enough information for someone to possibly steer me in the right direction?


-- g

 

[Shortmeister1]

Hi

You can't actually create a aggregated calculated column in DAX (e.g SUM, AVERAGE etc.). Calculated columns understand "row context" but are useless for aggregations.

You have to create a DAX Measure which you will then be able to manipulate in your Pivot table.

So I've mocked up a table displaying "Agent" and "Time".

The data model view looks like this:

In Excel, your Pivot Tables would look like this. You can see that the calculated column produces gibberish which a well designed measure is accurate.

Obviously, this is a simple use of a measure. The complexity that can be employed is huge.

I hope that helps you understand the data model a bit better. It's all conceptual!

Martin

ps - This isn't a paid for commercial - honest!! I have nothing to do with the people in question, but I found the Udemy course "Microsoft Excel: Business Intelligence w/ Power Query & DAX" from Maven Analytics really helpful when I started to get my head around this stuff. I think they're doing an extra special offer at the moment.