Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago
    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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    please Download pbix file here Listings.pbix

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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.