Forum Discussion
Cumulative Distinct Count For selected Dates
- 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
Can you please put some sample data / pbix file in googledrive or OneDrive and paste the link here, to figure a solution.
Cheers
CheenuSing
please Download pbix file here Listings.pbix
Hi Anonymous
I went through the pbix file.
I created a relationship between Listing History[ReportedDate_SID] and DateReported[Date_SID] using Manage Relationship under the modelling tab.
I Created a simple measure
01 TestActiveListings =
CALCULATE (
DISTINCTCOUNT ( 'Listing History'[ListingInstance] ),
( 'Listing History'[ListingStatus] = "US"
|| 'Listing History'[ListingStatus] = "AC" )
)Created a slicer by Year and Month Number from Date Reported table. And could see the result shown properly.
I am not aware of the logic you have built for your measure Activity Listing.
If this works for you mark this as solution and also give Kudos
Cheers
CheenuSing
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