Forum Discussion

jseow's avatar
jseow
Frequent Visitor
8 years ago
Solved

Cumulative Count by Date With Filter

Hi all,   I'm not sure that I've properly described my issues in the subject line, but essentially what I have are two tables, Products and Reviews, joined on a Product ID, with the Reviews also ha...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi jseow，

    Please create a measure using the following formula.

    COUNT =
    CALCULATE (
     DISTINCTCOUNT ( Reviews[Product ID] ),
     FILTER (
     ALL ( Reviews ),
     Reviews[Review ID] > 0
     && Reviews[Date] <= MAX ( Reviews[Date] )
     )
    )


    Then add the measure as value in your bar chart, you will get expected result.



    Please download the .pbix file for more details.

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi jseow，

Please create a measure using the following formula.

COUNT =
CALCULATE (
 DISTINCTCOUNT ( Reviews[Product ID] ),
 FILTER (
 ALL ( Reviews ),
 Reviews[Review ID] > 0
 && Reviews[Date] <= MAX ( Reviews[Date] )
 )
)


Then add the measure as value in your bar chart, you will get expected result.



Please download the .pbix file for more details.

Best Regards,
Angelia

jseow's avatar
jseow
Frequent Visitor
8 years ago

Thanks so much, that's perfect!