March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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.
Solved! Go to Solution.
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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
133 | |
91 | |
88 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
72 | |
68 |