Forum Discussion
Matrix total
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 , can you share formula, it may be because of row context. You might have to use values or summarize
Dear amitchandak ,
following is DAX