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
RogerSteinberg
Post Patron
Post Patron

Show the proportion of 0s against the total per day on a visual

Hi,

 

Story: I have a 0s and 1s for each day. I would like to visually show the proportion of 0s to the total counts per day on a visual.

 

I created a matrix putting date on rows, the column in question in the "columns" and "values" box. Then I right clicked on the show value as Percent of row total which works perfectly. I need that matrix turned into a visual keeping only the 0s  proportion.percentrow.png

Objective: How can I make a visual that will show case the 0s in % row total exactly as the matrix above. Do I have to create measures for this?

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

@RogerSteinberg 

You would yes.  Something list this will get you what you are looking for.

0 pct of total = 
VAR _zeros = 
    CALCULATE(
        COUNTROWS( 'YourTable' ),
        'YourTable'[Value] = 0
    )
VAR _Total =
    COUNTROWS( 'YourTable' )
RETURN 
    DIVIDE ( _zeros, _Total )

Then you put that measure in your chart values along with the date on the axis.

View solution in original post

2 REPLIES 2
jdbuchanan71
Super User
Super User

@RogerSteinberg 

You would yes.  Something list this will get you what you are looking for.

0 pct of total = 
VAR _zeros = 
    CALCULATE(
        COUNTROWS( 'YourTable' ),
        'YourTable'[Value] = 0
    )
VAR _Total =
    COUNTROWS( 'YourTable' )
RETURN 
    DIVIDE ( _zeros, _Total )

Then you put that measure in your chart values along with the date on the axis.

Such a quick and elegant solution, thank you

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.