cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mpicca13
Resolver IV
Resolver IV

Matrix Sorting Concatenated Calculated column by Max Value - Not working on Blank Product Names

In my fact table I have a calculated column called [Currency w/ Max Price] which simply take a measure called Max Price = MAX('table'[Selling Price]) and concatenates it to a column with Currency Types (Could be USD, MXN, EUR)

 

In the fact table i've sorted my calculated column by the selling price.

 

The goal here is to display the the calculated column value in a Matrix for each product (Show the Max price and currency type of each product)

 

This work just fine with the exception of rows with blank Product Names.

 

See images below:

 

Calculated column in fact table

Capture.PNG

 

Matrix showing calculated column results for rows correctly and incorrectly: (I've highlighted both the result and the expected value in the Correct rows and the Issue rows)

Capture1.PNG

 

Any ideas on how I should resolve this? 

1 REPLY 1
MFelix
Super User III
Super User III

Hi @mpicca13 ,

 

Be aware that the use of measures in a calculated column returns incorrect results because of the row context.

 

A measure is evaluated in the context of the cell evaluated in a report or in a DAX query, whereas a calculated column is computed at the row level within the table it belongs to.

 

So you problably need to check the calculation that you have for the column because I believe you can have incorrect data in there.

 

Looking at the column you have probably you can use the same code to create a measure to use in your matrix visualization and get the result you need.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.