Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to get a matrix to provide bookings and percentage of bookings (per day) in a given week. However, some weeks have no bookings and so when I use the values to give %RT, it leaves it blank as the total is 0. I need it to display 0% for each day instead of blank values.
I have tried to calculate %RT as a DAX measure as well, but it just filters out and does not give 0%. Is there any way I can use custom string field or other methods.
I hope someone can help me find a solution.
PowerBI Percentage measure of total
Solved! Go to Solution.
You will need to write it...
Measure =
VAR currentTotal = [Bookings]
VAR WeekDayTotal = CALCULATE([Bookings],ALLSELECTED(WeekDayName))
VAR Result = DIVIDE(currentTotal,WeekDayTotal,0)
RETURN IF(ISBLANK(Result),0,Result)
You will need to write it...
Measure =
VAR currentTotal = [Bookings]
VAR WeekDayTotal = CALCULATE([Bookings],ALLSELECTED(WeekDayName))
VAR Result = DIVIDE(currentTotal,WeekDayTotal,0)
RETURN IF(ISBLANK(Result),0,Result)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.