How to use the following Case statement on Power BI?

[Anonymous]

Hello,

I am new to Power BI. We are using a Case Statement calculated field on a different reporting tool. I am wondering if we can use similar logic on Power BI.

Old Logic : COUNT(DISTINCT CASE WHEN "Table"."Col1" = 'INV' THEN "Table"."Col2" END)/COUNT(DISTINCT "Table"."Col2")*100.00

How can I replicate the above logic on Power BI? 

Any help is appreciated.

Thanks

[parry2k · Accepted solution]

@Anonymous try following

you don't need to multiple by 100, just the format to percent.

New Logic = 
DIVIDE(
CALCULATE( DISTINCTCOUNT( Table[Col2] ), Table[Col1] = "INV" ),
DISTINCTCOUNT( Table[Col2] )
)

[Anonymous]

Thank you for a quick response. This works perfect.