Solved: Re: Divide two columns DAX

Anonymous · ‎03-19-2019

I have in one column 3 statements: Enabled, Never Logged In and Not Activated.

I need to create a formula that let me divide: Enabled/(Enabled+Never Logged In + Not Activated).

Please help!!!

v-yulgu-msft · ‎04-09-2019

Hi @Anonymous ,

Add below measure into a card visual.

percentage = 
DIVIDE (
    COUNTROWS ( FILTER ( ALLSELECTED ( Table5 ), Table5[Statement] = "Enabled" ) ),
    COUNTROWS ( ALLSELECTED ( Table5 ) )
)

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-yulgu-msft · ‎04-09-2019

Hi @Anonymous ,

Add below measure into a card visual.

percentage = 
DIVIDE (
    COUNTROWS ( FILTER ( ALLSELECTED ( Table5 ), Table5[Statement] = "Enabled" ) ),
    COUNTROWS ( ALLSELECTED ( Table5 ) )
)

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.