Forum Discussion

Parvez933's avatar
Parvez933
Icon for Helper I rankHelper I
3 years ago
Solved

Selected but also display all

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 ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.