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

[RogerSteinberg]

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.

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?

[jdbuchanan71 · Accepted solution]

@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.

[RogerSteinberg]

Such a quick and elegant solution, thank you