Create a measure to display in a card based only on a visual and not all page filter

[crombinator]

Hello,

So it seems I am almost there, but here is the issue. I have a table of people where they belong to two groups (Group A and Group B). The entire population on each visual can be displayed no issue, and if I apply a visual filter for Group B then I can see only that portion of the population in that filter.

The issue is I want to use a card that shows the total of all filtered population in that visual. As an example:

Total population is 100,000 with no filters for Group A/Group B. With Group A showing of hair colours in the donut chart, and the Group B shows eye color in that donut chart.

I apply an all Page filter to show me the population with blonde hair. That changes the total visual on both donuts to 40,000. Now I can go to the Group B visualization where I display eye colour, and I can change that visualization filter to only Brown. So the chart now displays as only 'Brown' and is 10,000.

The issue I have is I want a card inside each donut to display the total population for each filter. The Group A is easy because that is based on the All Page filter and so it will always show the correct total. The problem is the Group B I need to show the visualization applied filter. If the card just has: 

Hair Population = count(TotalPop[PersonId]) then that only shows the total based on the all pages filter.

I got close with:

Eye Population = CALCULATE ( COUNT (TotalPop[PersonId]),

KEEPFILTERS ( ( TotalPop[EyeColor] IN { "Brown", "Blue", "Hazel", "Green", "Other"} ) ) )

But obviously that is not based on the visualization filter, and just shows the total eye color population. Is there a way to JUST show the total for the eye colour filtered population based on the totals of the donut chart? I mean the amounts are in the data labels, but I am just starting to learn DAX and I am trying to figure out if I can get the totals as show from those labels.

[crombinator]

Here is an example with 50 elements. The card in the 'Eye Colour' does not have any Dax applied. I know that I can just apply the filter for the card visualization so that it matches the donut chart, but I was hoping to be able to do this using a DAX formula.

Here is the desired result with 1000 elements:

PersonId	hairColour	eyeColour
1	Red	Hazel
2	Brown	Hazel
3	Grey	Brown
4	Brown	Brown
5	Other	Other
6	Other	Hazel
7	Red	Hazel
8	Red	Green
9	Other	Green
10	Red	Blue
11	Grey	Brown
12	Other	Hazel
13	Grey	Hazel
14	Blonde	Blue
15	Blonde	Blue
16	Blonde	Other
17	Blonde	Blue
18	Brown	Other
19	Brown	Other
20	Brown	Green
21	Red	Green
22	Other	Other
23	Red	Brown
24	Grey	Hazel
25	Grey	Blue
26	Other	Green
27	Brown	Hazel
28	Brown	Other
29	Grey	Green
30	Grey	Other
31	Brown	Green
32	Blonde	Green
33	Red	Blue
34	Red	Blue
35	Other	Other
36	Red	Hazel
37	Brown	Blue
38	Brown	Brown
39	Other	Brown
40	Grey	Brown
41	Blonde	Other
42	Other	Green
43	Brown	Other
44	Blonde	Green
45	Red	Blue
46	Red	Other
47	Other	Green
48	Other	Brown
49	Grey	Hazel
50	Grey	Other

[Ritaf1983]

I got the file but still didn't understand what is the desired result...

[crombinator]

Sorry, my screenshot is still incorrect. Basically what I want is if I select the Visualization filter for eyeColour I want the card to reflect what is selected there. Instead of showing the Total like this:

I would like it to show the same value as the Visualization filter, and not the All Pages filter:

[Ritaf1983]

Sorry, I still don't understand....
Generally to ignore the filter you can use all / allselected dax functions.

Take a look at the linked video:
https://www.youtube.com/watch?v=6t5D7K8jZvc

Unfortunately, I can't suggest something more detailed.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[crombinator]

Here is a description of what I have done:

1. All Pages filter has hairColour selected as Blonde which then displays 190 for both charts
2. On the eyeColour chart you can select the Visualization filter as Brown which then shows my first example
3. And then the third example I want a Measure to use in a Card that will show the actual value of 35 without having to manually click the card and match the Visualization filter from the eyeColour donut chart. So if I select Brown/Blue filter on the donut chart it will show the total value of the selections in that card instead of having to select the Card and selecting Brown/Blue manually.

[Ritaf1983]

Hi @crombinator 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523