Reply
Frequent Visitor
Posts: 4
Registered: ‎04-26-2018
Accepted Solution

Percent of group total by another total

[ Edited ]

 

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%

 


Accepted Solutions
Super User
Posts: 4,103
Registered: ‎01-14-2017

Re: Percent of group total by another total

Hi,

 

You may refer to my solution in this file.

 

Hope this helps.

 

Untitled.png

View solution in original post


All Replies
Established Member
Posts: 238
Registered: ‎07-25-2017

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

Member
Posts: 121
Registered: ‎01-23-2018

Re: Percent of group total by another total

[ Edited ]

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

Super User
Posts: 4,103
Registered: ‎01-14-2017

Re: Percent of group total by another total

Hi,

 

You may refer to my solution in this file.

 

Hope this helps.

 

Untitled.png

Highlighted
Frequent Visitor
Posts: 4
Registered: ‎04-26-2018

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%.