Forum Discussion

Sujit_Thakur's avatar
Sujit_Thakur
Solution Sage
6 years ago
Solved

Matrix total

Dear PBI Family , PLease can anyone help me with solving this issue  Row total of my matrix is showing wrong value  As shown below both rows are measure and both rows have same value but still dif...
Need Help
  • Sujit_Thakur's avatar
    Sujit_Thakur
    6 years ago

    amitchandak  and v-chuncz-msft  and AntrikshSharma 


    i am super happy i got the problem , it was just the filter context , i tried to understand and then yes i did it!!!!
    i just made one more DAX in which i told power bi to see if my model column has only one value then ok give me Expected dist measure but if more than one model is avialable in filter context then sum row wise the expected dist measure .

    New DAX = IF(HASONEVALUE(Query1[Model]),[Exepected_dist],Sumx(values(Query[model]),[Expected_dist]))
    I hope this helps to someone like me who would have spend almost 2 days stucked in one thing 


    Regards ,

    Thakur Sujit

Sujit_Thakur's avatar
Sujit_Thakur
Solution Sage
6 years ago

Dear v-chuncz-msft , 

I saw some time ago you gave solution to such problem , I would be greatly thank ful to you if you can help here too

 

Please help, got stucked from 2 days

Regards 

Thakur Sujit

Sujit_Thakur's avatar
Sujit_Thakur
Solution Sage
6 years ago

amitchandak  and v-chuncz-msft  and AntrikshSharma 


i am super happy i got the problem , it was just the filter context , i tried to understand and then yes i did it!!!!
i just made one more DAX in which i told power bi to see if my model column has only one value then ok give me Expected dist measure but if more than one model is avialable in filter context then sum row wise the expected dist measure .

New DAX = IF(HASONEVALUE(Query1[Model]),[Exepected_dist],Sumx(values(Query[model]),[Expected_dist]))
I hope this helps to someone like me who would have spend almost 2 days stucked in one thing 


Regards ,

Thakur Sujit