PowerBI Displaying % of Flagged Columns in a bar chart

[emrei]

Hi everyone, I have the following data set. For each category, In a bar chart I am trying to show what % of parts are risky or not. Similar to this example but in powerbi. I would also love to have a subcategory drill down. Does anyone have any recommendations

[ryan_mayu · Accepted solution]

@emrei 

you can create a measure

Measure = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[risk]="Y"))/COUNTROWS('Table')+0

and drag category and sub-catogory to x-axis

click drill down to display subcategory

pls see the attachment below

[Ritaf1983 · Accepted solution]

Hi @emrei 
You can manipulate your drill level calculations with Isfiltered function, so you an use this DAX code:

Risk% =

IF (

    ISFILTERED ( 'Table'[Subcat] ),

    CALCULATE (

        DISTINCTCOUNT ( 'Table'[Part] ),

        FILTER ( 'Table', 'Table'[Risk] = "Y" )

    )

        / CALCULATE ( COUNTROWS ( 'Table' ), ALLEXCEPT ( 'Table', 'Table'[Subcat] ) ),

    IF (

        ISFILTERED ( 'Table'[Category] ),

        CALCULATE (

            DISTINCTCOUNT ( 'Table'[Part] ),

            FILTER ( 'Table', 'Table'[Risk] = "Y" )

        )

            / CALCULATE ( COUNTROWS ( 'Table' ), ALLEXCEPT ( 'Table', 'Table'[Category] ) )

    )

)+0

Link to a sample file 

 If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[ryan_mayu · Accepted solution]

@emrei 

you can create a measure

Measure = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[risk]="Y"))/COUNTROWS('Table')+0

and drag category and sub-catogory to x-axis

click drill down to display subcategory

pls see the attachment below