Selected but also display all

[Parvez933]

Hi,

We are trying to create a table and slicer which shows the below information in the form of 1 entry per selection:

Company Package A 1.Bronze A 2.Silver AA 1.Bronze AAA 1.Bronze AAA 3.Gold B 2.Silver BB 1.Bronze BB 2.Silver BB 3.Gold BBB 3.Gold C 2.Silver C 3.Gold CC 2.Silver CCC 1.Bronze

To explain indetail with a example:

The above table has to be shown as it is in the tab and there would be a filter called Pacakage with 3 entries

1. Bronze

2. Silver

3. Gold

and if I select 1. Bronze only the below 2 rows has to show, this is because AA and CCC have 1. Bronze only once and all other have 2/more entiries.

AA	1.Bronze
CCC	1.Bronze

Example 2:

If we select 2. Silver only 2 entries has to be shown, like wise for Gold

B	2.Silver
CC	2.Silver

Can anyone please help and also can anyone please help me how can I upload/attach any attachment here

[Parvez933]

Hi @Xinru Zhu,

This is the expectation and we have achieved it. Thank You for your help.

[Anonymous · Accepted solution]

Hi @Parvez933 ,

1. You need to create table to put the “Package” into the table, then use it as the slicer option, the code is as follows:

Table 2 = SUMMARIZE('Table','Table'[Package])

Then create a 1:N relationship between the tables

2. Create a new measure, and input the following code, and put the measure to the visual filter, set the condition that , the measure equal to 1

Measure = IF(ISFILTERED('Table 2'[Package]),IF(CALCULATE(COUNTA('Table'[Company]),'Table'[Company]=SELECTEDVALUE('Table'[Company]),ALL('Table'))=1,1,0),1)

^{The related Output}

If your Current Period does not refer to this, please clarify in a follow-up reply.

^{Best Regards,}

^{Xinru Zhu}

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