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.
I have data structured as such:
An Account can have multiple records in the same category. In such cases, their Revenue will be listed as the same value for each record. I need a MEASURE that will only sum the Revenue value ONE time per Account-Category combination. So in my example, Account 108392299 has two (2) records for the New category. Each record pulls in his revenue of $201.35. My resulting measure SummarizedRevenue, should only count the $201.35 ONE time because it is the same Account-Category combination. How can I construct such a measure?
Solved! Go to Solution.
If possible, i'd recommend going back to PowerQuery and just removing duplicate rows (unless there's a particular reason you need them?)
Otherwise, try a measure like:
Amt per Group =
var tempTable = SUMMARIZE('Table', 'Table'[Account], 'Table'[Catg], 'Table'[Amt])
return SUMX(tempTable, 'Table'[Amt])
hi @domtrump ,
try to plot with a measure like:
Sum =
SUMX(
SUMMARIZE(data, data[Account], data[Category], data[Revenue]),
data[Revenue]
)
it worked like:
hi @domtrump ,
try to plot with a measure like:
Sum =
SUMX(
SUMMARIZE(data, data[Account], data[Category], data[Revenue]),
data[Revenue]
)
it worked like:
If possible, i'd recommend going back to PowerQuery and just removing duplicate rows (unless there's a particular reason you need them?)
Otherwise, try a measure like:
Amt per Group =
var tempTable = SUMMARIZE('Table', 'Table'[Account], 'Table'[Catg], 'Table'[Amt])
return SUMX(tempTable, 'Table'[Amt])
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 |
---|---|
71 | |
37 | |
21 | |
19 | |
15 |
User | Count |
---|---|
125 | |
32 | |
27 | |
24 | |
23 |