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 PowerBI gurus !
I have build report that display protection level of the customers by amount of machines...
I am trying to build graph\chart\table that will display who was most contributing in the timeframe, who increased the most or alternate some table that shows up and down arrow with numbers on how much value increased...
example of table:
Solved! Go to Solution.
Hi @Max_Z ,
We can create a measure to show the increasement for each org
Increasement = VAR maxDay = MAX ( 'Table'[Day] ) VAR minDay = MIN ( 'Table'[Day] ) RETURN CALCULATE ( SUM ( 'Table'[MachinesInGroup] ), 'Table'[Day] = maxDay ) - CALCULATE ( SUM ( 'Table'[MachinesInGroup] ), 'Table'[Day] = minDay )
Then create another measure to get the most contributor
MostContributor = VAR t = SUMMARIZECOLUMNS ( 'Table'[OrgId], "Total", [Increasement] ) RETURN CALCULATE ( MAXX ( FILTER ( t, [Increasement] = MAXX ( t, [Increasement] ) ), [OrgId] ) )
If it doesn't meet your requirement, Please show the exact expected result based on the Tables that you have shared.
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Max_Z ,
We can createa measure to display who was most contributing in the timeframe:
TOPFGroup = MAXX(TOPN(1,'Table',[MachinesInGroup],DESC),[FGroupID])
Could you please provide more details about increased the most? What time range you want to compare with?
If it doesn't meet your requirement, Please show the exact expected result based on the Tables that you have shared.
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Dong Li,
It is not what I am looking for...
Provided measure shows wich group have most machines...
I need to calculate what is the increasing rate of machines in group by customer.
example table:
Day | OrgId | RbacGroupId | ProtectionLevelId | ProtectionLevel_name | MachinesInGroup |
17-09-19 00:00 | x | 123 | 3 | FullyAutomated | 10000 |
18-09-19 00:00 | x | 123 | 3 | FullyAutomated | 11000 |
19-09-19 00:00 | x | 123 | 3 | FullyAutomated | 10500 |
17-09-19 00:00 | y | 234 | 3 | FullyAutomated | 20000 |
18-09-19 00:00 | y | 234 | 3 | FullyAutomated | 21000 |
19-09-19 00:00 | y | 234 | 3 | FullyAutomated | 22000 |
So following that table, I need to calculate how much machines increased for each customer for entire dates (in that example 17-19) and report should be able to adapt to modification of the dates (so if I select specific dates in the report it will display data for these dates only).
Hi @Max_Z ,
We can create a measure to show the increasement for each org
Increasement = VAR maxDay = MAX ( 'Table'[Day] ) VAR minDay = MIN ( 'Table'[Day] ) RETURN CALCULATE ( SUM ( 'Table'[MachinesInGroup] ), 'Table'[Day] = maxDay ) - CALCULATE ( SUM ( 'Table'[MachinesInGroup] ), 'Table'[Day] = minDay )
Then create another measure to get the most contributor
MostContributor = VAR t = SUMMARIZECOLUMNS ( 'Table'[OrgId], "Total", [Increasement] ) RETURN CALCULATE ( MAXX ( FILTER ( t, [Increasement] = MAXX ( t, [Increasement] ) ), [OrgId] ) )
If it doesn't meet your requirement, Please show the exact expected result based on the Tables that you have shared.
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Great, thank you @v-lid-msft .
Just one question, is it possible to show several (top3/5) contributors instead of one ?
Hi @Max_Z ,
We can create a measure using following formula then put it into the Visual Filter, set the condion to meet your requirement
IncreseRank = VAR t = ADDCOLUMNS ( GROUPBY ( ALLSELECTED ( 'Table' ), 'Table'[OrgId] ), "Total", [Increasement] ) RETURN RANKX ( t, [Total], [Increasement] )
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |