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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
elenton
Helper II
Helper II

Matrix row totals and final total

Im pretty new to power bi and using a matrix for the first time.

I have the the following data: Order Persons Name (top level), orderid (drop down/expanded level)

How do i show the total orders next to the persons name based on total order numbers, but then have the final total row equal the total order for eveyone.

I have only tried the count and disticnt count options so far. Distinct count gives me the values i need at row level but not for the final total.

1 REPLY 1
v-yulgu-msft
Employee
Employee

Hi @elenton,

 

Please follow this article to provide more detailed information.

How to Get Your Question Answered Quickly

 

Regards,

Yuliana Gu

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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