Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I am 90% of the way in a calculation but I'm stuck now... I am summarising a table based on the filter context (if someone filters date in a date slicer). All I want to do is return the grand total of rows.
This is not what I want:
This is what I want:
This is my DAX so far:
Solved! Go to Solution.
Hi that table is an aggregation of counts by month. So it's not a raw table. I am trying to get a average of counts by month.
I was able to get the numerator correct, but the denominator not. Anyway, I found a solution that has worked as below.
AVG Ticket Volume =
VAR AVGIT =
CALCULATE (
AVERAGEX (
ADDCOLUMNS (
SUMMARIZE ( Tickets, 'Tickets'[Module], 'Dates'[MonthYear] ),
"@Count", CALCULATE ( COUNT ( Tickets[No] ) )
),
[@Count]
),
ALLSELECTED ()
)
RETURN
AVGIT
I'm having a hard time seeing why you need such complexity in your measure:
Can you tell me why something simple like ALL(Table) wouldn't work?
Hi that table is an aggregation of counts by month. So it's not a raw table. I am trying to get a average of counts by month.
I was able to get the numerator correct, but the denominator not. Anyway, I found a solution that has worked as below.
AVG Ticket Volume =
VAR AVGIT =
CALCULATE (
AVERAGEX (
ADDCOLUMNS (
SUMMARIZE ( Tickets, 'Tickets'[Module], 'Dates'[MonthYear] ),
"@Count", CALCULATE ( COUNT ( Tickets[No] ) )
),
[@Count]
),
ALLSELECTED ()
)
RETURN
AVGIT
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
58 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |