Forum Discussion

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

Constant count through out the time line

Hi All,   I would like to have a DAX measure where it shows the count of entire rows in a table and that being constant through out the time line.   For example in the given table1 image there ar...
Need Help
Show and Tell
Tips and Tricks
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi labuser1235 

try a measure like

CALCULATE(COUNTROWS(table1), ALL(table1[date sold]) )
  • labuser1235's avatar
    labuser1235
    Icon for Helper IV rankHelper IV
    6 years ago

    az38 Thank you so much for your quick response. 

    All(table1[dates old]) is giving me only 1 as constant line on that particular day. However, when tried allselected it worked perfectly fine.