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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Anonymous
Not applicable

based on drill down, the ratio should values

i need to measure like if i drill down apparel, in pricing driver, i need ratio is like base pricing  by netshipped gms pd /total(3015266/25229318), each each gl, it should give each pricer driver 1 net shipped gms pd, total of each gl.. same if expand pricing driver 1 netshipped gms pd .total(2139/3015266) ratio per gl should come like that. Please help with the measure.

 

swathi1997_1-1654681889072.png

swathi1997_2-1654687442716.png

 

 

 

 

 

1 ACCEPTED SOLUTION
v-eqin-msft
Community Support
Community Support

Hi @Anonymous ,

 

Got it. You may fistly calcualte the sum of each pricing driver1/2 by using ALLEXCEPT() , and then try ISINSCOPE() to change sub-total of rows in matrix.

 

But we need some data sample for quick assist.

You may refer to the blogs to know

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

 

Best Regards,
Eyelyn Qin

View solution in original post

1 REPLY 1
v-eqin-msft
Community Support
Community Support

Hi @Anonymous ,

 

Got it. You may fistly calcualte the sum of each pricing driver1/2 by using ALLEXCEPT() , and then try ISINSCOPE() to change sub-total of rows in matrix.

 

But we need some data sample for quick assist.

You may refer to the blogs to know

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

 

Best Regards,
Eyelyn Qin

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.