Combine 2 visuals/Data and convert to pivot

[sabd80]

Hi,

I have below visual that has 4 measures by date:

I have switched the measures to rows and the date to column as in the screenshot number 3, through the property "Switch values to groups rather than columns" under the Value as in the below screenshot number 2:

the DAX for the measure 2.Testing 25 percentile is:

2.Testing 25 percentile = 

CALCULATE(

    PERCENTILEX.EXC('Testing table', [UnitSale], 0.25),  ALLSELECTED('Testing table'[Product]), 'Testing table'[UnitSale]<> BLANK())

I have another visual as in screenshot number 4:

the measure  [UnitSale] = sum ('Testing table'[Unit Sale])

I want to have combine the data in screenshot number 3 and screenshot number 4 in one visual or a table like below:

I can't provide the data because the report is connected to an SSAS tabular model.

Can you help?

[Anonymous]

Hi @sabd80 ，
Based on your description, I can understand that you want to have a combined display of two visual objects. But power bi doesn't provide such an operation. You can merge the data at the data source if you want to achieve this. Because you said that this data is located on ssas, but you can provide the complete example data in excel. And attach your desired results. Please hide the private information in advance.

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly