topic Creating measure to count ids based on a filter previously applied in DAX Commands and Tips

Creating measure to count ids based on a filter previously applied

Anonymous — Thu, 21 Jul 2022 22:51:20 GMT

Hi all!

I have the following scenario:
Table A has 4 Columns
ID, Product ID, Salesnumber, CreatedDateTime

I'll have to filter the report by one specific ID initially, so we will be seeing the visuals for one specific ID always and of course I will have the name of the Product for that ID and the salenumber showing on simple card visuals (as result of the filter applied). Now, based on that filter applied initially, I would like to have:
1- A measure that would show me the count of IDs for past 5 days(for instance) - that are associated to the Product ID that is showing (as we filtered by one specific ID )

Let me know if the above is clear, I would be more than happy to share an example if required. I've been struggling with this and I can't find an answer on how to do it.

Thank you in advance!

Re: Creating measure to count ids based on a filter previously applied

vapid128 — Thu, 21 Jul 2022 23:00:54 GMT

count of IDs means DISTINCTCOUNT of IDs

past 5 days means the Latest of CreatedDateTime

IDs for past 5 days =

CALCULATE(

DISTINCTCOUNT([ID],

Filter(ALL('Table A'),

'Table A'[CreatedDateTime]>MAX('Table A'[CreatedDateTime]) -5

)

Re: Creating measure to count ids based on a filter previously applied

Anonymous — Tue, 26 Jul 2022 21:21:56 GMT

This doesn't cover the part that this distinct count would be for the specific product ID that was filtered in the beginning.

Example:

ID 8 gets selected -> Product ID is 101 -> what is required is the count distinct of Ids for that specific Product ID in last 5 days.
Is it possible?

Re: Creating measure to count ids based on a filter previously applied

vapid128 — Tue, 26 Jul 2022 21:55:47 GMT

CALCULATE(

DISTINCTCOUNT([Product ID],

Filter(ALL('Table A'),

'Table A'[CreatedDateTime]>MAX('Table A'[CreatedDateTime]) -5

)