Constant count through out the time line

[labuser1235]

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 are 8 rows and I want 8 to be constant throug the time line i.e from min(datetable[date) to max(table1[date sold]). So when we put that in a line visual its more like a straight line.

I can achieve it using a calculated column, however, I would need only a DAX Measure which can full fill this. 

[amitchandak · Accepted solution]

@labuser1235 ,

New measures =CALCULATE(countrrows(Table),ALLCROSSFILTERED(Table))

https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak...

[labuser1235]

@amitchandak Thank you so much. It worked like charm 🙂

[az38]

Hi @labuser1235 

try a measure like

CALCULATE(COUNTROWS(table1), ALL(table1[date sold]) )

[labuser1235]

@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.