Power BI: How to get chart of cases pr. costumer pr. 30 days.?

[Anonymous]

In Power BI I would like to make a chart showing the number of service cases pr. costumer for the last 30 days.

So fare, I have made a measurement showing the number of cases for the last 30 days:

Cases each 30. day = CALCULATE([Number of cases], DATESINPERIOD('Page 1'[Updated].[Date],TODAY(),-30,DAY)).

Every case has a uniqe case ID.

So the question is: How can I relate that to each costumer?

I hope someone can help. Thanks in advance!

BR Rebekka.

[Anonymous]

Hi. It did not help, since I cannot choose my number of cases is a measurement, witch I canput into your measurement formal

[Anonymous]

Hi @Anonymous ,

Try to add a filter. We often use

FILTER(ALLSELECTED('TABLENAME'),[COLUMNNAME]=MAX('TABLENAME'[COLUMNNAME]))

to gourp by.

For example,

Measure = CALCULATE(SUM('Table'[Sales]),FILTER(ALLSELECTED('Table'),[Customer]=MAX('Table'[Customer])))

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.