handling hierarchy in matrix table

[Anonymous]

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 Results

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

Output (Not Desired)

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

Thanks in advance!

[v-diye-msft]

Hi @Anonymous 

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.