I have a meaure I used to create a percentage of a value, however, It does not display as a percentage.
AutoDetect% = format(DIVIDE(COUNT('Incident Trends'[AutoDetect]),sum('Incident Trends'[IcM_TrendCount])), "0.0%")
I tried the Modeling tab, however, my only option is a Text field.
What am I missing?
Thanks,
Karen
Solved! Go to Solution.
Hi @kfschaefer
The format in Modeling tab is available for the measure without FORMAT Function(DAX) as below. If it is not your case, please share your data sample.
Regards,
Cherie
Hi @kfschaefer
The format in Modeling tab is available for the measure without FORMAT Function(DAX) as below. If it is not your case, please share your data sample.
Regards,
Cherie
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
125 | |
78 | |
67 | |
56 | |
56 |
User | Count |
---|---|
200 | |
104 | |
85 | |
80 | |
77 |