Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |