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.
Hey guys
I'm having trouble creating a measure that meets the following requirements:
I have a table view with production and target data for each location
I have a measure that calculates the gap (real - target) and makes the calculation weighted in relation to the total volume
Measure_GAP:
var gap = SUM('table'[real]) - SUM('table'[goal])
return SUM('table'[real]) * gap/ CALCULATE(SUM('table'[real]),ALL(table[local]))
I need to create a new measure that will return the sum of each line of Measure_GAP but ignoring the locality filter context
As per the example below
thank you all for your attention
Solved! Go to Solution.
Hi @DavidNunes7 ,
You can produce your required output in many ways, and one of them is as follows.
First, sumx your original measure over Local field as shown below to get the total of -0.875.
The next, write a second measure like below to ignore filter of Local field.
I attach a pbix file as an example.
Best regards,
Hi @DavidNunes7 ,
You can produce your required output in many ways, and one of them is as follows.
First, sumx your original measure over Local field as shown below to get the total of -0.875.
The next, write a second measure like below to ignore filter of Local field.
I attach a pbix file as an example.
Best regards,
Perfect!!!
Thank You
Hi,
Share the download link of the PBI file.
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 | |
61 | |
59 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |