Forum Discussion

Frequent Visitor

3 years ago

Merge 2 selectedvalues from different tables

I have a dataset containing sales of different stores, and am creating a report in which 2 stores can be selected and compared. The 'Current' and 'Comparative' slicers at the top left oper...

tamerj1

Community Champion

3 years ago

Hi robertvdleeuw
I did some trials. This should work

=
CALCULATE (
    SELECTEDVALUE ( Location[Location] ),
    TREATAS (
        {
            SELECTEDVALUE ( Current[Current] ),
            SELECTEDVALUE ( Comparative[Comparative] )
        },
        Location[Location]
    )
)

Please place this measure in the filter pane and select "is not blank" and apply the measure