How to get the other part of a percentage in Power BI DAX

[Anonymous]

Hi - I have a simple calculation to find a percentage of unavailable products

DIVIDE(COUNTA('Sales'[Out of Stock]), COUNTA('Sales'[Products]))

Its giving me the percentage of products Out of Stock from all products

What can I add to the DAX to get it to show me the percentage of Products that are in stock?

ie, if its showing 22% unavailable I want it to show 78% available

Thanks in advance!

[AlexisOlson · Accepted solution]

If you have X% and you want the remainder that totals to 100%, simply take 100% - X%.

1 - DIVIDE ( COUNTA ( 'Sales'[Out of Stock] ), COUNTA ( 'Sales'[Products] ) )

[Anonymous]

thanks - how do I write that into the expression? I cant figure that part out 😄

[AlexisOlson]

Did you miss the "1 - " part in the code I wrote?

[Anonymous]

Ah yes - sorry I did, I read that as the first code line 😄 Thanks, I was making it way more complicated that it needed to be