topic Re: Total of text in DAX Commands and Tips

Total of text

BishwaR — Tue, 05 Jan 2021 02:10:28 GMT

I have table like this. I created a measure

Count Of Line = districtcount(Item Line) as a result it is returning total value 3 but how can I get 5 instead because when I calculate the average of Count of Line it returns 3/5= 0.6 where as I want the value 5/5=1

Thank you

Re: Total of text

lbendlin — Tue, 05 Jan 2021 02:53:04 GMT

Use COUNTROWS() instead of DISTINCTCOUNT()

Re: Total of text

amitchandak — Tue, 05 Jan 2021 02:58:48 GMT

BishwaR , Try a measure like

Count Of Line = count(Table[Item Line])

Count Of Line = countrows(Table)

Count Of Line = distinctcount(Table[Item Line])