Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
gtomas
Regular Visitor

handling hierarchy in matrix table

Hi everyone,

 

I have a problem regarding the values when not including the client attribute in a matrix table.

 

The data that I am using is imported from a cube and the model has three dimensions (Product, Client, Family). We have the real price (PVP_REAL) and the recomended price (PVP_REC) as measures. Then, we calculated the PVP_REAL and PVP_REC measures in the following way:

PVP_REAL = AVERAGEX(Retail_Shooping,Retail_Shooping[PVP Real]);
PVP_REC = MEDIANX(Retail_Shooping, Retail_Shooping[PVP Recomendado])

 

The problem is that the final and desired value only works if we have the three dimensions in the matrix and I want to present it only with the Family and Product dimensions. 

In the following image, we present the desired results:

Desired ResultsDesired Results

If I don't use the Client dimension the results in the matrix are displayed as shown:

Output (Not Desired)Output (Not Desired)

Can anyone help how to get the desired results, but with 2 dimensions (Family and Product).

 

Thanks in advance!

1 REPLY 1
v-diye-msft
Community Support
Community Support

Hi @gtomas 

 

You might consider creating pbix file that will contain some sample data, upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.