Forum Discussion

BI_diva's avatar
BI_diva
Regular Visitor
5 years ago

DAX: Cumulative distinctcount incorrect on blank rows

Hi, I am unable to get a correct cumulative distinctcount, because my table has blank rows for some columns.   The formula for NoStudents I used is: CALCULATE( DISTINCTCOUNTNOBLANK(MyTable[NoStu...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

 

var LastDurationVisible = MAX( MyTable[Duration] )
return
	CALCULATE(
		SUM( MyTable[NoStudents] ),
		MyTable[Duration] <= LastDurationVisible
	)

 

  • BI_diva's avatar
    BI_diva
    Regular Visitor
    5 years ago

    Hi Daxer, thank you for your suggested answer. I have just given it a try, but unfortunately the result in the table is still the same.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      You have to show more than what you have. Certainly, my formula is totally correct for the table shown and I can  totally prove it. If it does not work for you, it means you've got something in there that is different than what you've shown.