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 am trying to get Max of sales for each category in a cross tab .below is the sample data i tried using MAXX but no luck
any help would be highly appreciated
Sample
Need to calculate max per each category here below case cateogry X should get 70 and category Y should get 200 in Crosstab
Category Year Sales
X 1998 50
X 1999 70
Y 1998 100
Y 1999 200
Thanks
Varun
Solved! Go to Solution.
Hi @Varun51 ,
Try this:
CALCULATE(
MAX(table[Sales]),
ALLEXCEPT(
talbe,
talbe[Category]
)
)
Or this:
Measure =
MAXX(
SUMMARIZE(
talbe,
talbe[Category],
"Sales", MAX(table[Sales])
),
[Sales]
)
Many methods can be used to find the maximum value in groups.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Varun51 ,
Try this:
CALCULATE(
MAX(table[Sales]),
ALLEXCEPT(
talbe,
talbe[Category]
)
)
Or this:
Measure =
MAXX(
SUMMARIZE(
talbe,
talbe[Category],
"Sales", MAX(table[Sales])
),
[Sales]
)
Many methods can be used to find the maximum value in groups.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |