Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need some support in calculated field in matrix table. Any help is much appreciated.
I have 2 columns
CLASS_CONF and Change_class (which has 2 seperate values ClassChange and NoClassChange).
Original Table:
I need to have a calculated column as below.
Matrix and red column is expected column:
Thank you
c5966
Solved! Go to Solution.
Thank you for your help
I understood how to do this, first I need to group my class confidence and then use your divide function.
Hi @c5966 ,
If I understand that you are looking for a Dax formula, try Accuracy = Divide([No Class Change], [Class Change] + [No Class Change]). For the first line in your matrix, you would have the result below.
If this solves your issue, please mark this as the solution. Kudos are nice too!
Nathaniel
Proud to be a Super User!
My table with measure just make sure it is formatted for percentage
d
If this solves your issue, please mark this as the solution. Kudos are nice too!
Nathaniel
Proud to be a Super User!
Also my NoClassChange column is calculated column:
it has one and 0 values
thanks for the quick resonse.
I have a questin, is it a caculated measure or calculated column which you have created below?
Thanks
You are right, calculated column is what it is as opposed to a measure. Working on another project, and was to quick with my answer.
So did this answer your issue?
Proud to be a Super User!
Not sure what you are asking...should be the same with 1 or 0. Just reference the column name. Divide will return a blank unless you give it an alternative return for a divide by zero. See Dax Divide on the web:
DIVIDE(<numerator>, <denominator> [,<alternateresult>])
numerator | The dividend or number to divide. |
denominator | The divisor or number to divide by. |
alternateresult | (Optional) The value returned when division by zero results in an error. When not provided, the default value is BLANK(). |
A decimal number.
Alternate result on divide by 0 must be a constant.
If this answers you issue please mark as the solution.
Nathaniel
Proud to be a Super User!
Thank you for your help
I understood how to do this, first I need to group my class confidence and then use your divide function.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |