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 a variable that refers to a measure...
Test Measure =
I have been trying a combination of SUM, SUMX, etc. but cant figure it out.
Thanks in advance
Solved! Go to Solution.
I believe i've found an anternative solution to the above, so putting question on hold,
Hey @StuartSmith ,
your post is pretty confusing. Can you please upload an example file?
Otherwise first question, I don't see the measure [Test Measure] in your pictures. What am I supposed to see in the screenshot? And what are you expecting?
Best regards
Denis
I believe i've found an anternative solution to the above, so putting question on hold,
Sorry, the "7a) Total Regional KPI" is the "Test" measure, but just with a different name. I normally include an example file, but cant this time.
The 1st screenshot is showing that the measure displays a numerical value for each building. But I want to group the buildings together so I can just have regions and remove the "Building Code" column, similar to the 2nd screenshot and all the building code values are totaled together per region.
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
46 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |