cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Prodigy

## Frequency based on the criteria

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

1 ACCEPTED SOLUTION
Community Support

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.

3 REPLIES 3
Community Support

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.

Post Prodigy

Hi,

Thank you so much for and reply.

Anonymous
Not applicable

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

Thanks

Raj