Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
try this
=if(sum(tableName[hours sent])=0,blank(),[measure])
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])
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.
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.
try this
=if(sum(tableName[hours sent])=0,blank(),[measure])
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |