I have a slicer (Quarter) in report.
Where I selected quarter 1 then it should select only week 1 to week 13.
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|
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.
Solved! Go to Solution.
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
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.