Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
Proud to be a 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
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |