Forum Discussion

meg222's avatar
meg222
Frequent Visitor
3 years ago

Show same Top N categories for different visualisations

Hi,   I have a visualisation below which shows the top 3 answers for the category which is selected in a slicer. The "% A4" is a measure calculated like this:  % A4 = CALCULATE(DISTINCTCOUNT(A4[U...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi meg222 ,

 

If you turn off the interaction, it will be difficult for us to to use the filter in visual 1 in our calculation. Here I suggest you to inactive the relationship between "Demographics" table and "A4" table.

% A4 for Visual1 = 
VAR _DIVIDE =
    DIVIDE (
        CALCULATE (
            DISTINCTCOUNT ( A4[UNIQUE_ID] ),
            A4[Response] = "Yes",
            USERELATIONSHIP ( A4[A4], Demographics[Category] )
        ),
        CALCULATE (
            DISTINCTCOUNT ( A4[UNIQUE_ID] ),
            USERELATIONSHIP ( A4[A4], Demographics[Category] )
        )
    )
RETURN
    _DIVIDE
% A4 for Visual2 =
VAR _LIST =
    VALUES ( Demographics[Category] )
RETURN
    IF (
        MAX ( A4[A4] ) IN _LIST,
        DIVIDE (
            CALCULATE ( DISTINCTCOUNT ( A4[UNIQUE_ID] ), A4[Response] = "Yes" ),
            DISTINCTCOUNT ( A4[UNIQUE_ID] )
        )
    )

Do not inactive the interaction from slicer in viusal2, and use top3 [% A4 for  Visual1] to filter both visuals.

Best Regards,
Rico Zhou

 

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

meg222's avatar
meg222
Frequent Visitor
3 years ago

Hi Rico Zhou,

 

Thank you for taking a look! I'm having some trouble with making the relationship between the demographics table and A4 inactive - it then isn't filtering the first visual for the selected category. 

 

Also my demographics table is a bit different - it doesn't contain the same categories as are in A4 - it has other categories which need to be able to filter both visual 1 and visual 2. I need something which looks like the below with a slicer for Podcast and a slicer for Gender (which are in the demograhics table)

 

 

I've attached a sample pbix file here:

https://we.tl/t-AhpqUeSBqE 

 

Thanks,

Meg