Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a question to calculate MAX from all values here.
"Date Unit" is coming from a table, called "Calendar"
"Satisfaction" is coming from another table, called "Opinion"
"Score" is a measure, which is SUM(Opinion[Value])
These 2 tables Calendar and Opinion have relationship between them, based on date column.
As you can see I have 2 group by here, by Date Unit and Satisfaction
I have 2 questions:
Anyone have the answer? Any help will be greatly appreciated! Thank you
Solved! Go to Solution.
@gggar , Create a new measure like this and use
maxx(summarize(Opinion, Calendar[Date Unit], Opinion[satisfaction], "_1", [Score]),[Score])
Hi @gggar ,
You could take a look at ALL() and ALLEXCEPT() function.
https://docs.microsoft.com/en-us/dax/all-function-dax
https://docs.microsoft.com/en-us/dax/allexcept-function-dax
Measure = MAXX(ALL(Opinion),[score])
Measure 2 = MAXX(ALLEXCEPT('Opinion','Calendar'[date unit]),[score])
Best Regards,
Jay
Hi @gggar ,
You could take a look at ALL() and ALLEXCEPT() function.
https://docs.microsoft.com/en-us/dax/all-function-dax
https://docs.microsoft.com/en-us/dax/allexcept-function-dax
Measure = MAXX(ALL(Opinion),[score])
Measure 2 = MAXX(ALLEXCEPT('Opinion','Calendar'[date unit]),[score])
Best Regards,
Jay
Hi @amitchandak ,
Thank you for the reply.
The Total is correct, which is 503. Is it possible to return the Total (this 503) to each row?
Thank you!
@gggar , Create a new measure like this and use
maxx(summarize(Opinion, Calendar[Date Unit], Opinion[satisfaction], "_1", [Score]),[Score])
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |