Forum Discussion
Solved
SUM Measure ignoring the locality filter context
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...
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,
Share the download link of the PBI file.