cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
c5966 Regular Visitor
Regular Visitor

Calculated field with matrix

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:

Original.png

 

I need to have a calculated column as below.

 

 

Matrix and red column is expected column: 

Expected.png

 

Thank you

c5966

1 ACCEPTED SOLUTION

Accepted Solutions
c5966 Regular Visitor
Regular Visitor

Re: Calculated field with matrix

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.

 

Accuracy = CALCULATE(divide(sum('table'[NoClassChange]), sum('table'[ClassChange])+sum('table'[NoClassChange])), fILTER(ALL('table'), 'table'[MEDTR_FRONT_VDAC_CLASS_CONF] = EARLIER('table'[MEDTR_FRONT_VDAC_CLASS_CONF])))

View solution in original post

8 REPLIES 8
Nathaniel_C Super Contributor
Super Contributor

Re: Calculated field with matrix

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

No Class Change.PNG

 

c5966 Regular Visitor
Regular Visitor

Re: Calculated field with matrix

Appreciate your help.
 
Accuracy = Divide([NoClassChange],[ClassChange]+[NoClassChange])
 
This DAX formula did not give expected output ,please see below screenshot.
123.png
 
I would really appreciate any help on this topic.
 
Thank you.
 
 
Nathaniel_C Super Contributor
Super Contributor

Re: Calculated field with matrix

@c5966 

My table with measure just make sure it is formatted for percentage

per.PNGd

 

If this solves your issue, please mark this as the solution. Kudos are nice too!

Nathaniel

Highlighted
c5966 Regular Visitor
Regular Visitor

Re: Calculated field with matrix

thanks for the quick resonse. 

 

I have a questin, is it a caculated measure or calculated column which you have created below?

 

Thanks

 

c5966 Regular Visitor
Regular Visitor

Re: Calculated field with matrix

Also my NoClassChange column is calculated column:

it has one and 0 values

 

NoClassChange = if(export_lbj_8753[Change_Class] = "NoClassChange", 1,0)
ClassChange = if(export_lbj_8753[Change_Class] = "ClassChange",1,0)
 
how do we create divide formula on aggregated data? for this calculation.
 
 
Nathaniel_C Super Contributor
Super Contributor

Re: Calculated field with matrix

@c5966 

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?

 

Nathaniel_C Super Contributor
Super Contributor

Re: Calculated field with matrix

@c5966 

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:

 

Syntax

DAXCopy
DIVIDE(<numerator>, <denominator> [,<alternateresult>])  

Parameters

Term Definition
numeratorThe dividend or number to divide.
denominatorThe 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().

Return value

A decimal number.

Remarks

Alternate result on divide by 0 must be a constant.

 

If this answers you issue please mark as the solution.

 

Nathaniel

c5966 Regular Visitor
Regular Visitor

Re: Calculated field with matrix

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.

 

Accuracy = CALCULATE(divide(sum('table'[NoClassChange]), sum('table'[ClassChange])+sum('table'[NoClassChange])), fILTER(ALL('table'), 'table'[MEDTR_FRONT_VDAC_CLASS_CONF] = EARLIER('table'[MEDTR_FRONT_VDAC_CLASS_CONF])))

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)