Forum Discussion
Creating measure to count ids based on a filter previously applied
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...
vapid128
Solution Specialist
Solution SpecialistCALCULATE(
DISTINCTCOUNT([Product ID],
Filter(ALL('Table A'),
'Table A'[CreatedDateTime]>MAX('Table A'[CreatedDateTime]) -5
)
)