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.
Hi.
I have created 2 measures using same formula, but one of my DAX is not working and other is working fine.
I have attached screenshots of the same.
Solved! Go to Solution.
@SanketBhagwat
So you need the year with the highest value:
Qualification =
MAXX(
TOPN (
1,
ALLSELECTED (WC_YEARS[YEAR]),
[Highest Qualification]
),
WC_YEARS[YEAR]
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
The 2nd screenshot doesn't show the Qualification measure, you need to clear on it and share the screenshot.
You use ALLSELECTED(WC_Years[Year]) instead of GROUP BY
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
You are getting this error because the TOPN function is returning multiple values. There are multiple years for which the value is equal to Highest Qualifications.
I just noticed that there are multiple year values for which the 'Highest Qualifications' measure is giving the same value.
Do you guys know any DAX which will return only 1 year value.
@SanketBhagwat
You can use MAXX
Attendnace =
MAXX (
VALUES(WC_YEARS[YEAR]),
[Highest Attendance]
)
Qualification =
MAXX (
VALUES(WC_YEARS[YEAR]),
[Highest Qualification]
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Sorry, but the solution you provided didn't gave the correct answer.
@SanketBhagwat
So you need the year with the highest value:
Qualification =
MAXX(
TOPN (
1,
ALLSELECTED (WC_YEARS[YEAR]),
[Highest Qualification]
),
WC_YEARS[YEAR]
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |