Frequency based on the criteria

[Saxon10]

Hi,

How can I do frequence based on the criteria in Power BI using DAX.

I have a data table with information about the sales of products Id by customer with date.

What I`m trying to achieve here - How frequently we deliver the product id to the customer by date.

Data

Date	Product ID	Customer	Qty
05/05/2021	12345	Tata	1
05/05/2021	12345	Tata	2
05/05/2021	12345	Tata	34
05/05/2021	12345	Tata	5
05/05/2021	1254	Hero	8
05/05/2021	1254	Hero	9
05/05/2021	1254	Hero	10
05/05/2021	1254	Hero	11
05/05/2021	1254	Hero	12
06/05/2021	12345	Tata	1200
06/05/2021	1254	Honda	1
06/05/2021	1254	Honda	1
06/05/2021	1254	Honda	1

[v-yangliu-msft · Accepted solution]

Hi  @Saxon10 ,

Here are the steps you can follow：

1. Create measure.

Sum =
CALCULATE(SUM('Table'[Qty]),FILTER(ALL('Table'),'Table'[Customer]=MAX('Table'[Customer])&&'Table'[Date]=MAX('Table'[Date])))

 2. Result:

Best Regards,

Liu Yang

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

[Saxon10]

Hi,

Thank you so much for and reply. 

[Anonymous]

To make it clear, can you post the expected output for the above given data?

Thanks

Raj