Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sreddy47652
Helper II
Helper II

Based on slicer selection measure to display

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.

 

 

 

1 ACCEPTED SOLUTION
v-eqin-msft
Community Support
Community Support

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

Eyelyn9_1-1653011058727.png

 

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.

View solution in original post

2 REPLIES 2
v-eqin-msft
Community Support
Community Support

Hi @sreddy47652 ,

 

Any updates?

 

Best Regards,
Eyelyn Qin

v-eqin-msft
Community Support
Community Support

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

Eyelyn9_1-1653011058727.png

 

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.