Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Oh, right on. So rather than trying to convert text to number, create a DAX measure that counts the rows.
FTE = COUNTROWS( [YourTable] )
@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.
Is each row in the dataset always a value of 1 for FTE?
User | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |