FTE column not showing grand total

[pbi_newie]

Hello,

I am pulling together data from a live database (via SSAC) and therefore have no control over the dataset. Below is some FTE data i have pulled fromt he source and as you can see, the last column shows a FTE count however the table does not total this column.

The data type for the FTE column is TEXT however since it is a live connection, i am unable to edit the data type.

I am a complete novice when it comes to DAX so any help would be greatly appreciated.

Thank you!

[pbi_newie]

@CoreyP  the dataset always has a value of 1 for FTE from what i can see.

[CoreyP]

Oh, right on. So rather than trying to convert text to number, create a DAX measure that counts the rows. 

FTE = COUNTROWS( [YourTable] )

[pbi_newie]

@CoreyP  Thanks for your suggestion - this doesn't quite work in my case as even though the FTE column always has a value of 1, there are multiple recurrences of Employees therefore i have gone with the below. Let me know if there is a better way of doing this.

FTE = DISTINCTCOUNTNOBLANK(Table[Employee ID])

[CoreyP]

Is each row in the dataset always a value of 1 for FTE?