Want to Display Data label as Category name with value percentage

[Shloka_Lakhani]

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.

[Anonymous · Accepted 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.