Row Counts

[Kerrymr]

I have a table visual  Like below.

Trying really hard to make column Row count =1  for each row and the total = 8.

Current measure :

RowCount = CALCULATE(Counta(PowerBI_VarianceReporting[EmployeeID]),ALLSELECTED(PowerBI_VarianceReporting))

Have to use measure becuase it's direct query.

Thanks in advance!

[Greg_Deckler · Accepted solution]

What about:

RowCount = 1

And see this for the total:

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376