Forum Discussion

btalahmbong's avatar
btalahmbong
Advocate II
9 years ago
Solved

Count Text Values by Specific Date

Is it possible to count a set of rows for a set of dates, then show that sum on a visual as the total on the last date(only last date showed) ? For Example; We have a table with 2 columns Date and ...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi btalahmbong,

    I reproduce your scenario using the sample data. Create two measures using the fomulas.

    The last day = CALCULATE(MAX(Test[DATE]),ALL(Test))
SALES = CALCULATE(COUNTA(Test[TITLE]),FILTER(Test,Test[DATE]<=Test[The last day]))


    Create a table visual, select two measures as value level, you will get the expected result as follows.



    Thanks,
    Angelia


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

Hi btalahmbong,

I reproduce your scenario using the sample data. Create two measures using the fomulas.

The last day = CALCULATE(MAX(Test[DATE]),ALL(Test))
SALES = CALCULATE(COUNTA(Test[TITLE]),FILTER(Test,Test[DATE]<=Test[The last day]))


Create a table visual, select two measures as value level, you will get the expected result as follows.



Thanks,
Angelia