Forum Discussion

Evelin_'s avatar
Evelin_
Helper I
1 year ago
Solved

Multiple version selection

Dear Community,    I would like to ask you about possible options, best way to model the following idea:   Comparing lots of data for 2 versions , but each version could be selected individually....
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi Evelin_ 

     

    Use two disconnected table slicers (no relationshiop to fact) and reference the columns from those in measures:

     

    Please see the attached pbix.

     

johnt75's avatar
johnt75
Super User
1 year ago

You could create 2 tables for use in the slicers, e.g.

Slicer 1 = DISTINCT( 'Table'[Version] )
Slicer 2 = DISTINCT( 'Table'[Version] )

Do not create any relationships with these tables, just use them in the slicers.

The measure you would use for the comparison would depend on the way you want to compare them, but an example showing the simple difference between them could be

Comparison =
VAR Version1 =
    CALCULATE (
        SUM ( 'Table'[Volume] ),
        TREATAS ( VALUES ( 'Slicer 1'[Version] ), 'Table'[Version] )
    )
VAR Version2 =
    CALCULATE (
        SUM ( 'Table'[Volume] ),
        TREATAS ( VALUES ( 'Slicer 2'[Version] ), 'Table'[Version] )
    )
VAR Result = Version1 - Version2
RETURN
    Result