Forum Discussion

Seven's avatar
Seven
Regular Visitor
8 years ago
Solved

Group by with Filter

Hello,   I have the Data like this:                     Hobbies          Country Mark          Swimming       Germany David         Football           Italy Maria         Swimming       German...
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI Seven,

     

    You can refer to below graph to know how to create a visualization to achieve your requirement.

     

    Regards,

    Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Seven,

     

    You can switch visual type to line and clustered column chart and use below measure as line value:

    Analytic Line = 
DIVIDE (
    CALCULATE (
        COUNT ( Table1[Name] ),
        VALUES ( Table1[Hobbies] ),
        VALUES ( Table1[Country] )
    ),
    CALCULATE ( COUNT ( Table1[Name] ), ALLEXCEPT ( Table1, Table1[Country] ) ),
    -1
)

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Seven,

 

You can refer to below graph to know how to create a visualization to achieve your requirement.

 

Regards,

Xiaoxin Sheng

  • Seven's avatar
    Seven
    Regular Visitor
    8 years ago

    Hi Xiaoxin Sheng,

     

    thank you very much. This is helping a lot.

     

    Is it now possible to set a constant line, which is different for every filter.

     

    The line should bei the total count of people of every country.

    e.g. 2 german people are swimming. In the data there 4 germans. So it should be made clear (with the line at 4), that half of the Germans are swimming.

     

    Regards,

    Sven

     

     
    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Seven,

       

      You can switch visual type to line and clustered column chart and use below measure as line value:

      Analytic Line = 
DIVIDE (
    CALCULATE (
        COUNT ( Table1[Name] ),
        VALUES ( Table1[Hobbies] ),
        VALUES ( Table1[Country] )
    ),
    CALCULATE ( COUNT ( Table1[Name] ), ALLEXCEPT ( Table1, Table1[Country] ) ),
    -1
)

      Regards,

      Xiaoxin Sheng