Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I would like to ask for your help on how to get the sum of max period displayed
In the screenshot below, the totals are all in sum by column but I want to display in TOTAL in first 3 columns the sum of max period:
I don't know how to post my pbix here on this message, can't see the icon to upload pbix.
Solved! Go to Solution.
Hi,
I have solved for Adjustment. Please solve for Cost and Expenses yourself. You may dowload the PBI file from here.
Hope this helps.
@summer18 - If I understand correctly, it sounds like Lookup Min/Max (without the lookup) https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434
or a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.
Hi @harshnathani ,
Here's the link of the pbix
https://drive.google.com/file/d/1_Mzqk8euQaW2c5dXpNOSVaukGKp5e7V6/view?usp=sharing
Hi,
I have solved for Adjustment. Please solve for Cost and Expenses yourself. You may dowload the PBI file from here.
Hope this helps.
You are welcome.
@summer18 , Try same for all measures adjustments, sales, cost and expense
lastnonblankvalue(Table[Date],Sum(Table[adjustments]))
and take the max of date/period in the visual, use invoice no as row/axis/not summarized
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
108 | |
96 | |
95 | |
74 | |
71 |