Remove Repeating Values in Matrix table

DAX DAX Calculations
1

Hi ,

Please I have a measure (_budget) in a matrix table that has no relationship with the filtered rows (zones), I will like to make the zones values blank and also return only zones with _actual values

image
image600×513 23 KB

I have tried using different suggestion like using the hasonefilter etc , but I could not get it. Please any idea on an aproach

sample pbix file attached

Thank you

repeating Values.pbix (33.7 KB)

2

Hello @akeko,

Thank You for posting your query onto the Forum.

So you want to transform the result as per the screenshot provided below -

Results
Results1868×835 42.9 KB

In that case, below is the measure provided for the reference -

_Budget - Harsh = 
IF( NOT ISINSCOPE( Zone[Zone] ) ,
    SUM( Sheet1[Budget] ) )

I’m also attaching the working of the PBIX file for the reference purposes.

Hoping you find this and meets your requirements that you’ve been looking for.

Thanks and Warm Regards,
Harsh

Repeating Values - Harsh.pbix (34.3 KB)

3

Thanks, It worked. I have never used the inscope function