Comparisons of one category against another - clustered column chart

[Anonymous]

Hello, 

I would like to show one category, compared to all the others in the data set, by a different category. For example, one store against all the others by age of customers. And I want to be able to change the stores via a slicer

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try to output the value of different ages for all stores except the selected store by Measure. But it can only be placed in 2 charts, because the values of the clustered column chart cannot be placed in 2 variables at the same time. I know the effect you are trying to achieve, comparing one store to all others in the same graph, which is not currently possible.

Measure = 
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER (
            ALL ( 'Table' ),
            [Store] <> SELECTEDVALUE ( 'Table'[Store] )
                && [Category] = SELECTEDVALUE ( 'Table'[Category] )
        )
    )

Best Regards,

Community Support Team _Charlotte

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