Forum Discussion

rob_vander2's avatar
rob_vander2
Helper II
1 year ago
Solved

Comparative Analysis using DAX

Hi All,   I have one table with columns Country and Sales. I want to do compartive analysis in same graph.  For that I need to have two set of country selections (two different slicers with country...
  • Greg_Deckler's avatar
    Greg_Deckler
    1 year ago

    rob_vander2 Create 2 disconnected slicer tables:

    Slicer 1 = DISTINCT( 'Table'[Country] )

Slicer 2 = DISTINCT( 'Table'[Country] )

    You could then create measure such as:

    Sales 1 = 
  VAR __Countries = DISTINCT( 'Slicer 1'[Country] )
  VAR __Table = FILTER( 'Table', [Country] IN __Countries )
  VAR __Result = SUMX( __Table, [Sales] )
RETURN
  __Result

Sales 2 = 
  VAR __Countries = DISTINCT( 'Slicer 1'[Country] )
  VAR __Table = FILTER( 'Table', [Country] IN __Countries )
  VAR __Result = SUMX( __Table, [Sales] )
RETURN
  __Result
Greg_Deckler's avatar
Greg_Deckler
Community Champion
1 year ago

rob_vander2 Create 2 disconnected slicer tables:

Slicer 1 = DISTINCT( 'Table'[Country] )

Slicer 2 = DISTINCT( 'Table'[Country] )

You could then create measure such as:

Sales 1 = 
  VAR __Countries = DISTINCT( 'Slicer 1'[Country] )
  VAR __Table = FILTER( 'Table', [Country] IN __Countries )
  VAR __Result = SUMX( __Table, [Sales] )
RETURN
  __Result

Sales 2 = 
  VAR __Countries = DISTINCT( 'Slicer 1'[Country] )
  VAR __Table = FILTER( 'Table', [Country] IN __Countries )
  VAR __Result = SUMX( __Table, [Sales] )
RETURN
  __Result