cancel
Showing results for
Did you mean:
Member

## 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

 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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: slicing measure problem: Measure is not getting sliced.

try this

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

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
5 REPLIES 5
Super User

## Re: slicing measure problem: Measure is not getting sliced.

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 a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Member

## Re: slicing measure problem: Measure is not getting sliced.

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.

Super User

## Re: slicing measure problem: Measure is not getting sliced.

try this

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

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Moderator

## Re: slicing measure problem: Measure is not getting sliced.

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

Member

## Re: slicing measure problem: Measure is not getting sliced.

Hi @Eric_Zhang,

Yes it worked. Thanks @MattAllington

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 53 members 1,126 guests
Recent signins: