Forum Discussion
Incorrect Total after what-if parameter
Hi all, I am building below matrix and need to convert the SqFt to Capacity (CufT) (SqFt * Density). As 2 warehouses have different Density, and I write below DAX. However, I still cannot...
hi, it should be
Return
SUMX(SUMMARIZE([Warehouse]),if(SELECTEDVALUE(Warehouse[Warehouse])="GSW",GSW,if(SELECTEDVALUE(Warehouse[Warehouse])="Oneill GA",Oneill,blank())))
Hi.
Thanks for your reply, but i cannot modify the DAX and it is showing error
I have uploaded a demo PBI file. Thanks.
https://drive.google.com/file/d/1w3jwbXEBFTieszKYZl4Z6PG_3zqVf93w/view?usp=sharing