Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I was using a measure to calculate some values in % and it was working okay (I just selected the option "%" on the Modeling tab). After some time using that, we figured out that when some error occurs on the calculation, the measure shows "NaN".
I need to transform this "NaN" in a different text, to show that we does not have any value, something like "-", that is our standard. But when i changed the measure form, it became impossible to select any data formatting (probably because now it is not only numbers).
Here are the measure forms:
Measure (old form) = (SUM('IOP Input'[# of Category C machines Step 3 - AM]))/(SUM('IOP Input'[# of all machines in category C]))
Measure (new form) = IFERROR((SUM('IOP Input'[# of Category C machines Step 3 - AM]))/(SUM('IOP Input'[# of all machines in category C])); "-")
So now, i cannot select the "%" type of data, and my number is not displaying in the way I want.
Someone have a suggestion?
Solved! Go to Solution.
Hi @felipr02,
You can use DIVIDE function and FORMAT function to work through your issue.
Measure= FORMAT(DIVIDE(SUM('IOP Input'[# of Category C machines Step 3 - AM]),SUM('IOP Input'[# of all machines in category C]),"-"),"percent")
Regards,
Xiaoxin Sheng
Hi @felipr02,
You can use DIVIDE function and FORMAT function to work through your issue.
Measure= FORMAT(DIVIDE(SUM('IOP Input'[# of Category C machines Step 3 - AM]),SUM('IOP Input'[# of all machines in category C]),"-"),"percent")
Regards,
Xiaoxin Sheng
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |