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
aktripathi2506
Helper IV
Helper IV

slicing measure problem: Measure is not getting sliced.

HI,

 

I have a slicer (Quarter) in report.

Where I selected quarter 1 then it should select only week 1 to week 13.

 

Problem:

 

When I select quarter 1, other columns are getting sliced except the measure.

 

This is how my out put look like

 

weekhour spenttotal hoursMeasure
1210098%
2410096%
3720097%
4430099%
5625098%
6235099%
7812093%
8932197%
9208075%
10106083%
111234096%
122112283%
13510095%
14  100%
15  100%
16  100%
17  100%
18  100%
19  100%
20  100%
21  100%
22  100%
23  100%
24  100%

 

Column hour is total hours spent for week and total hours is total hours available for the week.

I wanted to calculate the efficiency and for that I have used measure = 1-hours spent/total hours.

 

All I want is when i select the slicer it should display only those value for the measure too.

 

Please advise.

 

1 ACCEPTED SOLUTION

try this

 

=if(sum(tableName[hours sent])=0,blank(),[measure])



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

5 REPLIES 5

The issue is your measure on the right. It displays 100% if hours spent is blank. Change this measure by wrapping it in an if statement, like

 

=if([hours soent]=0,blank(),[measure])



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Thank you @MattAllington for reply.

 

in my case hour spent is a column, and when I create the new measure then IF condition is not allowing me to include a column it is suggesting me all other measure but not any columns.

 

So in this case how should I put the condition.

@aktripathi2506

 

How is it going in your case? @MattAllington's last reply should work based on my test. If you have further questions, feel free to post.

Hi @Eric_Zhang,

 

Yes it worked. Thanks @MattAllington

try this

 

=if(sum(tableName[hours sent])=0,blank(),[measure])



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

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.