slicing measure problem: Measure is not getting sliced.

[aktripathi2506]

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

week	hour spent	total hours	Measure
1	2	100	98%
2	4	100	96%
3	7	200	97%
4	4	300	99%
5	6	250	98%
6	2	350	99%
7	8	120	93%
8	9	321	97%
9	20	80	75%
10	10	60	83%
11	12	340	96%
12	21	122	83%
13	5	100	95%
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.

[MattAllington]

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])

[aktripathi2506]

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.

[Eric_Zhang]

@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.

[aktripathi2506]

Hi @Eric_Zhang,

Yes it worked. Thanks @MattAllington

[MattAllington · Accepted solution]

try this

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