DAX filter problems

Question

Hi, I hope you can help me with my little problem.&nbsp;I have this table.&nbsp;&nbsp;Book&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Reference #&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Code&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AmtEco&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Ref01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1/1/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1,000Pro&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Ref01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2/5/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1,000Eco&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Ref02&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2/1/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2,000Eco&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Ref02&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2/3/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2,000&nbsp;My measure are as follows :&nbsp;EcoAmt = Sumx ( Table , if( Book = "Eco", Table[Amt] , 0 )ProAmt = Sumx&nbsp;( Table , if( Book = "Pro", Table[Amt] , 0 )&nbsp;What i expected my visual table would look like&nbsp;Ref #&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Code&nbsp; &nbsp; &nbsp; &nbsp;EcoAmt&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ProAmtRef101&nbsp; &nbsp; &nbsp; &nbsp; 101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,000&nbsp;However, this doesnt seem to be the case. Any ideas on how to fix this?&nbsp;Any inputs would be greatly appreciated.&nbsp;&nbsp;Thank you!&nbsp;

amitchandak · Accepted Answer

jmcph , This should work. what is the wrong you are getting? You should also get a row for Ref102.
&nbsp;
try measure like
Sumx (filter(Table,[Book] = "Eco"), Table[Amt])Sumx (filter(Table,[Book] = "Pro"), Table[Amt])

Forum Discussion

DAX filter problems

2 Replies

Related content

FILTERING PROBLEM

DAX optimization problem

Filter problems

LastDate filter problem

Problem with filters in Power Bi service