cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ksangha Frequent Visitor
Frequent Visitor

Percent of group total by another total

 

I have below data and I have created simple table visualization in Power BI. 

 

IDstatusRange
1C730
2D650
3D690
4P690
5C690
6C710
7D750
8C650
9C690
10D690
11C770
12C690
13D690
14C730
15C710
16C650
17P650
18C670
193670
20P770

Capture.PNG

When the user clicks on any status in table 1, I want to find Percent total from the whole dataset which is 20 records.

i.e. User clicks on D result should display total records with Status D in that range/ total records in that range.

For 650 range there are 4 records and one record is with Status D, so 650 --- 25%(1/4)

 

What is the best way to achieve this? 

RangePercent of D records
65025.00%
69042.86%
750100.00%

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Percent of group total by another total

Hi,

 

You may refer to my solution in this file.

 

Hope this helps.

 

Untitled.png

4 REPLIES 4
Interkoubess Established Member
Established Member

Re: Percent of group total by another total

Hi @ksangha,

 

How do you get for Range 750, 100% and 42.86% for range 690 when selecting D?

 

Let me know and i can give it a try.

 

Ninter

Re: Percent of group total by another total

@ksangha Can you explain the calculation for those numbers 25%, 42.86% and 100%?

Super User
Super User

Re: Percent of group total by another total

Hi,

 

You may refer to my solution in this file.

 

Hope this helps.

 

Untitled.png

ksangha Frequent Visitor
Frequent Visitor

Re: Percent of group total by another total

There are 4 records in Range 650 and one record is Status D, so for 650, 1/4=25%.