If selected year

[Harsh]

Hello @pedroccamara,

Thank You for posting your query onto the Forum.

Just a minor change in the formula, instead of hard-coding the Year you can mention the Year column from the dates tables. And at the end you can just replace it with “BLANK()” function or simply write it as 0 if no year is selected. Or else you can also mention that if no year is selected show the default value as “Measure1”.

And another thing is you sure that you want to hard-code the figures because those are just the static numbers. Just few hours back I’ve posted the solution where our member hard-coded the numbers and was not able to slice and dice.

You can just check out the post. Providing the link below for the reference. Hoping your case is absolutely different than the one provided.

Thanks and Warm Regards,
Harsh

2 measures in a donut chart

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 …