How to show Total and Percentage in 2 2 different columns for a category?

[dsandip]

Hi,

How to show % in Colullumn C like below:

Complaints Type	No Of Complaints	Percnt%
A	12	28%
B	14	33%
C	17	40%

I have created a measure like below:

No Of Complaints = SUM(Complaint_NO) and place it in column B, but I have to show Cercentage in collumn C(in Percnt%) with below formulla:

for like

 Complaint type= A, it will be 12/(12+14+17) [means total Complaint], so it will be 28%

and  Complaint type= b, it will be 14/(12+14+17) [means total Complaint], so it will be 33%

So, how can I achieve that? or what will be the DAX for this? please help me.

[Ashish_Mathur · Accepted solution]

Hi,

Write this measure

Measure = divide([No of complaints],calculate([No of complaints],all(Data[Complaints Type]))

Hope this helps.

[Daniel29195]

@dsandip 

%measure = 

var current_sum = SUM(Complaint_NO) 
var total =  calculate ( SUM(Complaint_NO) ,  removefilters(table_name[Complaints_col_name]))

return

divide ( current_sum, total,  0 ) 

If my answer helped sort things out for you, feel free to give it a thumbs up and mark it as the solution! It makes a difference and might help someone else too. Thanks for spreading the good vibes! 👍🤠