Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Everyone!
I'm having issue to solve one problem.
I'm having next report:
Sales[Percent] is a Measure:
Percent = SUM(Sales[Sum])/SUM(FilialsSales[Sum])
Okay, it works.
Now I need to find MAX value of Sales[Percent] (it will be 0,198).. And devide each Percent value by MAX value of [Percent]:
0,184/0,198; 0,157/0,198; 0,038/0,198; .... etc
But I don't know how to find MAX.. Is it really? Help me please! =(
Maybe I chose wrong way?((
P.S.
Data of tables(not full, only part):
Sales :
FilialSales:
Solved! Go to Solution.
Hi @SerG
Try this one
Percent / Max Percent = DIVIDE ( [Percent], MAXX ( ADDCOLUMNS ( SUMMARIZE ( ALLSELECTED ( Sales ), [AdminName], Cities[City], "SUM", SUM ( Sales[Sum] ) ), "Percent", CALCULATE ( SUM ( Sales[Sum] ) ) / CALCULATE ( SUM ( FilialsSales[Sum] ) ) ), [Percent] ) )
Hi, I'm having a similar problem.
I have items with a profit margin. I calculated via measure the rank of the profit margin and would now like to divide the rank number by the maximum number of rank.
Any hints?
Hi @SerG,
If you can please share this file to onedrive/google drive, I can't get your file through that link.
In my opinion, I'd like to suggest you to create a summary table as variable in your measure, then use it to result the max percent.
Sample: not so sure if it suitable for your situation.
Max Percent = SUMX ( SUMMARIZE ( ALLSELECTED ( Table ), Table[AdminName], Table[City], "SUM",SUM(Table[SUM]), "Percent", [Percent] ), [Percent] )
Regards,
Xiaoxin Sheng
Hi @SerG,
I modify my formula to summary calculated result as the variable table, then use maxx function to get the max result from summary table.
Max Percent = MAXX ( SUMMARIZE ( ALLSELECTED ( Sales ), [AdminName], [City], "SUM Sales", SUM ( [Sum] ), "SUM Filials", SUMX ( FILTER ( ALL ( FilialsSales ), FilialsSales[City] = Sales[City] ), FilialsSales[Sum] ) ), [SUM Sales] / [SUM Filials] )
Notice: if your data contains any privacy data, please do mask sensitive data before sharing.
Regards,
Xiaoxin Sheng
Hi @SerG
Try this one
Percent / Max Percent = DIVIDE ( [Percent], MAXX ( ADDCOLUMNS ( SUMMARIZE ( ALLSELECTED ( Sales ), [AdminName], Cities[City], "SUM", SUM ( Sales[Sum] ) ), "Percent", CALCULATE ( SUM ( Sales[Sum] ) ) / CALCULATE ( SUM ( FilialsSales[Sum] ) ) ), [Percent] ) )
Hi,
Share the link from where i can download the pbix file.
Hi! Here is the link to download the pbix file:
dropmefiles\.com\/wKFH1
PS
Remove "\" from the link
Hi,
I get a message saying that the file is corrupt.
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |