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, I have a dashboard like this, what I want is that for the #Turnovers by city column, it will return the city total
E.g. for city Beauport, the #Turnovers by City should all have 37 in each row.
what I have now is:
what I want is :
The measure I used is:
try sumx of your #Turnovers by City measure over dim(city) table
Hi Gabry,
I tried to revised the measure to
but it doesn't work..
nope I meant a new measure = sumx(your prev measure, dimtable).
Couldn't you upload the pbix with sample data?
Hi Gabry, I tried to use the sumx to create a new measure.. but it's still not wokring..
I am sorry, but the data is confidential, I could not post it online due to the policy.
but still thanks for your help!!
User | Count |
---|---|
86 | |
81 | |
68 | |
63 | |
54 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |