SUM FILTERED DATA WITH DAX

[ian_abq]

Can you help me with this DAX calculation?

I have a table with 3 collums that I want to sum using filters.

In this case I want to show that IDA (809147) have "18" Fractions in the Course "5".

Therefore, I want to agrupate IDA by Course, sum the fractions of each course and then show only the hightest course of each IDA.

I'm leaving a pbix file below.

file 

Thanks

[PhilipTreacy · Accepted solution]

Hi @ian_abq 

Download your PBIX file with the below added.

If I understand correctly, you can do what you want by having a table with the IDA, Max of Course and then using a measure in the 3rd column which is

Max Frac = CALCULATE(SUM('data'[Fractions]), FILTER('data', 'data'[IDA] = SELECTEDVALUE(data[IDA]) && 'data'[Course] = MAX('data'[Course])))

Regards

Phil