Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
77 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |