Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
User | Count |
---|---|
120 | |
69 | |
69 | |
57 | |
50 |
User | Count |
---|---|
167 | |
82 | |
68 | |
65 | |
53 |