Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hello,
I want something like:
And i am stuck over here. I have created something like:
I appreciate your prompt response in advance, as it would be very helpful for me.
Solved! Go to Solution.
Hi @Shloka_Lakhani ,
(1) Here's my test data.
(2) Then create a measure.
Measure =
var _a=SUM('Table'[Value])
var _b=CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Type1]))
RETURN DIVIDE(_a,_b)
(3) The result is then as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Shloka_Lakhani ,
(1) Here's my test data.
(2) Then create a measure.
Measure =
var _a=SUM('Table'[Value])
var _b=CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Type1]))
RETURN DIVIDE(_a,_b)
(3) The result is then as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
98 | |
61 | |
47 | |
36 | |
34 |