Hello @Anu,
Thank You for posting your query onto the Forum.
As @Greg had mentioned earlier, measures will work appropriately and you shall be able to filter it if they’re written and calculated as per the slicer selections required.
The reason why it didn’t work in your case was because you had hard coded the numbers in your Sold and Unsold measures. Below are the formulas provided for the reference -
Sold Measure = 1650000000
And
Unsold Measure = 500000000
Therefore, it was not able to slice and dice as per the filters selection.
Below are the revised measures provided for the reference that I’ve written in your file -
Sold Measure - Harsh =
CALCULATE( [Total Measure] ,
FILTER( Donut ,
Donut[Type] = "Sold" ) )
And
Unsold Measure - Harsh =
CALCULATE( [Total Measure] ,
FILTER( Donut ,
Donut[Type] = "Unsold" ) )
Now, if you observe after writing both of these measures it will be able to slice and dice as per the selection made into the slicer. Below are the screenshots of the results provided for the reference -
I’m also attaching the PBIX file of the working for the reference.
Hoping you find this useful and meets your requirements.
Thanks and Warm Regards,
Harsh
Measures in a Donut Chart.pbix (19.9 KB)