cancel
Showing results for
Did you mean:
Regular Visitor

## 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

1 ACCEPTED SOLUTION
Super User

Hi @ian_abq

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

If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!

Super User

Hi @ian_abq

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

If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!

Announcements