Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Sum over one criterion

Hello all, I have a table with various information. I have an order. Different material numbers are assigned to this order. In my measure, the correct number is now displayed based on the smallest ...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
3 years ago

Hi Anonymous 

 

Download example PBIX file.

 

I don't have access to your file and hence your measure, but you could use this to sum the value per order 

 

 

Measure = CALCULATE(SUM('DataTable'[Value]), FILTER(ALL('DataTable'), 'DataTable'[Order] = SELECTEDVALUE('DataTable'[Order])))

 

 

Giving this

 

Regards

 

Phil