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
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.
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.
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.
Yes it worked. Thanks @MattAllington
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!