Based on slicer selection measure to display

[sreddy47652]

Hi Team, I have a slicer call E&c Completion status and few meausres top of this columns. when i select E&c Completion status has completed i want to display values for only That column and remaining need to display has zero. Same when i select completion staus has overdue only that columns need to display values remaining columns are zero. But right now below when i select any status the values are showing so please help me to fix this.

In above table all calucaltions are simple calucaltions.

[Anonymous]

Hi @sreddy47652 ,

Any updates?

Best Regards,
Eyelyn Qin

[Anonymous · Accepted solution]

Hi @sreddy47652 ,

Sorry for that the information you have provided is not making the problem clear to me.

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data to help us clarify your scenario.

You could take a good look at the blogs to know

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

In addition, I have a simple test on my side for your reference.  There is a new table with all statuses for slicer.

Measure = CALCULATE(SUM('Table'[Value]),FILTER('Table',[E&c Completion status] in ALLSELECTED('Status Slicer'[E&c Completion status])))+0

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.