Forum Discussion
Cumulative Distinct Count For selected Dates
Hi, I have a table that has property listings everyday, I have a measure that already gets CUMULATIVE count of number of active properties on whole table/site on Last Day of month. I need to create...
- This measure was built to consider aggregate only when expirydate is null. But source data didn’t have anything null, after Investigation I found out ETL was wrong. Now this measure is working as expected. Thanks for the help
Hi Anonymous ,
Not very clear about the logic you have built for your measure Activity Listing. Does replacing MAX with MIN in above measure meet your requirement?
FILTER
(
ALL('Listing History'[ExpiryDate])
,[ExpiryDate] > MIN('Date Reported'[DateValue])
)
,FILTER
(
ALL('Listing History'[EffectiveEndDate])
,[EffectiveEndDate] >= MIN('Date Reported'[DateValue])
)
Would you please illustrate your scneario with some simplified dummy data? And show us desired result.
Regards,
Yuliana Gu
This measure was built to consider aggregate only when expirydate is null. But source data didn’t have anything null, after Investigation I found out ETL was wrong. Now this measure is working as expected. Thanks for the help