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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors