Who was most contributing customer (and how much increased)

[Max_Z]

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:

[v-lid-msft]

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.

[Max_Z]

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).

[v-lid-msft · Accepted 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.

[Max_Z]

Great, thank you @v-lid-msft .

Just one question, is it possible to show several (top3/5) contributors instead of one ?

[v-lid-msft]

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.