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.
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 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |