Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Hemansi11
New Member

Percentage of Row Totals to display 0% for a row with no data in matrix visual

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 

example.png1.png2.png

 

1 ACCEPTED SOLUTION
BrianConnelly
Resolver III
Resolver III

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)

View solution in original post

1 REPLY 1
BrianConnelly
Resolver III
Resolver III

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)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors