can we show two matrix in one as I did in Excel

[adnankabina]

Hello I need your help. Is it possible in power what i have created in Excel. One matirx with % and other marix with numbers and shows grand total at bottom. Attached is picture.  

[audreygerred · Accepted solution]

Perfect - these are what you will put into your calculation group

OTA% = [OTA%] and use the dynamic formatting to make it be % ('#.#%')

Deliveries = [Deliveries]

[v-xinruzhu-msft · Accepted solution]

Hi,

Thanks for the solutions @Johnndan  and @audreygerred  provided, and i want to offer some more information for user to refer to.

hello @adnankabina , based on your description, you can refer to the following solution.

Sample data 

Sample measure

OTA% = DIVIDE(SUM('Query1'[Value]),CALCULATE(SUM('Query1'[Value]),ALLEXCEPT('Query1','Query1'[ID])))

Deliveries = SUM('Query1'[Value])

1.You can create a new table called it type, like the following, then select the name column and select sort by index column.

2.Create a Result measure.

Result = SWITCH(SELECTEDVALUE('Type'[Name]),"OTA%",[OTA%],[Deliveries])

Then click the format in measure tools to dynamic.

Then input the follwing code.

IF(SELECTEDVALUE('Type'[Name])="OTA%","0.00%")

And you can refer to the following link about the dynamic format.

Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn

3.Put the following field to the matrix

4.In property of the matrix, set the position of row subtotal to bottom.

Output

Best Regards!

Yolo Zhu

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

[Johnndan]

I am not expert in it but creating matrices with percentages and numbers in Power Query is achievable. You can use Power Query to transform your data and calculate percentages, then use Power Pivot or Power BI to create matrices and display grand totals. 
Hope this helps..

[audreygerred]

Hello! Yes, you can create this in Power BI in a matrix utilizing a calculation group and your dimension. In the below screenshot, my calculation group and the dim of category is in Rows. In my example of the calculation group I have Time Intelligence measures, but you can use whatever measures you want. You can see that in teh same matrix I have some items showing as a %. Here is an article I wrote about creating calculation groups (this was before you could natively do them in Power BI desktop through the modeling tab as long as you have the preview feature enabled, but the method is very similar): http://powerbiwithme.com/2023/08/10/the-calculation-group-edition/ 

[adnankabina]

format is different but it will work. Thanks, what I wanted % value on top and numbers should be at botoom

I shown in my first picture above

[audreygerred]

It's all just in how you choose to arrange the items in your calculation group (I happened to have my % measure last, but you can put yours in any order that you want). I have re-arranged my order so that the % for YoY is now on top:

[adnankabina]

I have not created any measure. I will appreicate if you forward your measure to get some idea how you did. Thanks

[audreygerred]

What is your formula for deriving OTA% and Deliveries? 

[adnankabina]

OTA% = IF(SUM(Query1[OTA_KEYED])=0, "", 1-

DIVIDE(SUM('Query1'[LATE]), SUM('Query1'[OTA_KEYED])))

Deliveries= SUM(Query1[DELIVERY_NUMBER])

[audreygerred · Accepted solution]

Perfect - these are what you will put into your calculation group

OTA% = [OTA%] and use the dynamic formatting to make it be % ('#.#%')

Deliveries = [Deliveries]