Forum Discussion
SUM FILTERED DATA WITH DAX
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.
Thanks
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
1 Reply
- PhilipTreacy
Super User
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