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 there,
I have three table,
Group,Product,Sales
And I want to creat a new measure to show the max value for sales by groupname.
How to do this ? Please help me.
BRs
Dora.
Solved! Go to Solution.
Hi,
thank you for your explanation, and please check the below picture and the attached pbix file.
The new measure has to be written like below, and then you can select this measure as a "Field Value" inside the Conditional Formatting -> Background color option.
Max sales value by groupname color format: =
VAR maxsales =
CALCULATE ( MAX ( Sales[Sales] ), ALLEXCEPT ( Sales, 'Group'[GroupName] ) )
RETURN
IF ( SUM ( Sales[Sales] ) = maxsales, "Red" )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@dorayeh161923 Find the attached PBIX file for your reference. Refer the Relationship tab for joining between tables. then simply take sales and GroupName into simple table or visual.
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
It is for creating a new measure.
Max sales value by groupname: =
SUMX ( VALUES ( 'Group'[GroupName] ), CALCULATE ( MAX ( Sales[Sales] ) ) )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi @Jihwan_Kim ,
Sorry I told not so clear,
My final purpose is to do like this.
The max turn background color in the same groupname.
How to do this? Thanks a lot.
BRs
Dora.
Hi,
thank you for your explanation, and please check the below picture and the attached pbix file.
The new measure has to be written like below, and then you can select this measure as a "Field Value" inside the Conditional Formatting -> Background color option.
Max sales value by groupname color format: =
VAR maxsales =
CALCULATE ( MAX ( Sales[Sales] ), ALLEXCEPT ( Sales, 'Group'[GroupName] ) )
RETURN
IF ( SUM ( Sales[Sales] ) = maxsales, "Red" )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@dorayeh161923 , Join sales with product table
then you can show
max(Sales[sales])
or
maxx(values(Product[Group Name]) , calculate(sum(sales[sales])))
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 |
---|---|
107 | |
106 | |
79 | |
71 | |
67 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |