Conditional Count Measure

Anonymous — Wed, 21 Jul 2021 16:25:57 GMT

Hi Everyone,

I am a fairly new user of PowerBi and I am having difficulties in creating a meausure that counts the number of distinct rows of a table and if the ID is a certain number, then this count is multiplied by two.

In coding it would be fairly easy, but i am not sure how i would do this as a PowerBi measure:

If StorageType = ("200 (Rack Doble Prof.)" OR "203 (Rack Doble Prof.)" OR "283 - 284 (Cam.Choc)"), THEN DISTINCTCOUNT('WM Stock(AMS-10)'[STORAGE_BIN])*2 Else DISTINCTCOUNT('WM Stock(AMS-10)'[STORAGE_BIN])

I am attaching the following visualization that I create to facilitate the comprehension of what I want to do. This visualization is a matrix that counts the rows, but what i would like to do is have the exact same table, such that the rows 200 (Rack Doble Prof.), 203 (Rack Doble Prof.) and 283 - 284 (Cam.Choc) are all multiplied by two.

Thank you!!

Re: Conditional Count Measure

Anonymous — Wed, 21 Jul 2021 16:36:03 GMT

I ended up using the method that is found here: Solved: Conditional Measures - Different Conditions - Microsoft Power BI Community

Very Useful!

topic Conditional Count Measure in DAX Commands and Tips

Conditional Count Measure

Re: Conditional Count Measure