Conditional Count Measure

[Anonymous]

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!!

[Anonymous · Accepted solution]

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

Very Useful!