Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello
I want to have in my column "max sales" the maximum of the values displayed in my table.
Here in the example below I would like to show in the column "max sales" : 1 195 256 in all the lines.
Do you how I can do that in a DAX formula?
thank you
Solved! Go to Solution.
@claxxx , Assume sales is a measure and you are using month year column in row
calculate( maxx(values(Table[Year Month]),[sales]), allselected() )
Thank you a lot! It works 🙂
@claxxx , Assume sales is a measure and you are using month year column in row
calculate( maxx(values(Table[Year Month]),[sales]), allselected() )
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 98 | |
| 72 | |
| 50 | |
| 48 | |
| 42 |