Forum Discussion

Bostox's avatar
Bostox
Regular Visitor
3 years ago
Solved

Cummulative Count by Date with Dates

hi power bi community I've searched the forum looking for an answer but couldn't find any. so i have to ask you I have a Timestamp Database with date and time HH:MM:SS making requests that are diff...
Need Help
  • Bostox's avatar
    Bostox
    3 years ago

    Found Solution

     

    Work with Filters and Delete Blank Data

     

    Responsive Cummulative =

    CALCULATE(
        COUNTROWS('Table'),
        FILTER(
            ALLSELECTED('Table'),
            'Table'[Date] <= MAX('Table'[Date]) && NOT(ISBLANK('Table'[Date]))
        )
    )
     
    In case you dont need delete blank data
     

    Responsive Cummulative =

    CALCULATE(
        COUNTROWS('Table'),
        FILTER(
            ALLSELECTED('Table'),
            'Table'[Date] <= MAX('Table'[Date])
        )
    )
Bostox's avatar
Bostox
Regular Visitor
3 years ago

Found Solution

 

Work with Filters and Delete Blank Data

 

Responsive Cummulative =

CALCULATE(
    COUNTROWS('Table'),
    FILTER(
        ALLSELECTED('Table'),
        'Table'[Date] <= MAX('Table'[Date]) && NOT(ISBLANK('Table'[Date]))
    )
)
 
In case you dont need delete blank data
 

Responsive Cummulative =

CALCULATE(
    COUNTROWS('Table'),
    FILTER(
        ALLSELECTED('Table'),
        'Table'[Date] <= MAX('Table'[Date])
    )
)