Forum Discussion

ROFELLM's avatar
ROFELLM
Regular Visitor
2 years ago

cumulative count for all rows by date question

Hello all,

DAX Beginner here. I need help with a formular.

 

My dummy data:

I'd like to have a bar chart, where it cumalates each entry. "Eingetragen am" is my date column.

What I expect: January: 2, February 2, March 3, April 4, May 4, June 5, July 5 and so on...

I don't know how to implement this. I tried to use the quick measures and came pretty close. The formular so far: 

 

CumulativeCount =

IF(

    ISFILTERED('Tabelle1'[Eingetragen am]),

    ERROR("Quickmeasures mit Zeitintelligenz können nur über die von Power BI bereitgestellte Datumshierarchie oder die primäre Datumsspalte gruppiert oder gefiltert werden."),

    CALCULATE(

        COUNTA('Tabelle1'[Name]),

        FILTER(

            ALL('Tabelle1'[Eingetragen am]),

            'Tabelle1'[Eingetragen am] <= MAX('Tabelle1'[Eingetragen am])

               )

        )

    )

 

My Date Table (calculated table)

 

is linked like this: 

 

 

What it looks like:

 

if I select "show elements without values" it's not what I want 😞 

Any help is appreciated! Thanks in advance!

 

1 Reply