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
We have to use all the filters which is given in measure "Active Listing" as this has filter for expired listings. If you add same filters I get same reults as Active listings.
Hi Anonymous
Can you state in simple English the logic you want to filter before arriving at the final result. That will be of great help.
Cheers
CheenuSing