Forum Discussion

labuser1235's avatar
labuser1235
Icon for Helper IV rankHelper IV
6 years ago
Solved

Cumulative count with Blanks

Hi All,   I want the cumulative values where I was want to include blanks in the count. I had tried && where it counts blanks as well yet it doesnt work. As per the countrows it should start from 8...
Need Help
Show and Tell
Tips and Tricks
  • Icey's avatar
    Icey
    6 years ago

    Hi labuser1235 ,

     

    Try this:

    Count =
CALCULATE (
    COUNTROWS ( Table1 ),
    FILTER ( ALLSELECTED ( Table1 ), Table1[Date Sold] >= MIN ( DateTable[Date] ) )
)
    + CALCULATE ( COUNTBLANK ( Table1[Date Sold] ), ALL ( Table1 ) )

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • labuser1235's avatar
    labuser1235
    6 years ago

    Thank you so much Icey . I have tried another way too which worked as well. 

     

    Count =
CALCULATE (
    COUNTROWS ( Table1 ),
    FILTER ( ALLSELECTED ( Table1 ), Table1[Date Sold] >= MIN ( DateTable[Date] ) || ISBLANK(TABLE1[DATE Sold]) )
)

     

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

Hi labuser1235 ,

 

Try this:

Count =
CALCULATE (
    COUNTROWS ( Table1 ),
    FILTER ( ALLSELECTED ( Table1 ), Table1[Date Sold] >= MIN ( DateTable[Date] ) )
)
    + CALCULATE ( COUNTBLANK ( Table1[Date Sold] ), ALL ( Table1 ) )

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • labuser1235's avatar
    labuser1235
    Icon for Helper IV rankHelper IV
    6 years ago

    Thank you so much Icey . I have tried another way too which worked as well. 

     

    Count =
CALCULATE (
    COUNTROWS ( Table1 ),
    FILTER ( ALLSELECTED ( Table1 ), Table1[Date Sold] >= MIN ( DateTable[Date] ) || ISBLANK(TABLE1[DATE Sold]) )
)