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.