Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Compare price

Hello I have a very simple table.
I need to pick a Country and then show price of all other countries. So, if I pick Australia, I need to see All other countrise and price, but do not show Austratia.


Thanks

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    Should be able to use the same basic concept to create a flag variable. First, don't connect your slicer to your table. Then create a flag measure like:

     

    Measure Flag = 
VAR __selected = MAX('Table'[Column]) //value from slicer
RETURN
IF(MAX([Country]) = __selected,0,1)

    Filter on this measure.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous,

     

    Create a calculated table which lists all slicer selections. This table should be unrelated to source data table.

    slicerTable = VALUES('TB1'[Country])

    Add below measure to visual level filters, set its value to 0.

    check = IF(SELECTEDVALUE(slicerTable[Country])=SELECTEDVALUE(TB1[Country]),1,0)

    To calculate the price of selected country as a comparison, please create below measure.

    value for selected country = CALCULATE(SUM(TB1[Price]),FILTER(TB1,TB1[Country]=SELECTEDVALUE(slicerTable[Country])))

    Best regards,

    Yuliana Gu

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I'm not looking to aggregate data, simple want to show country and price in grid mode of all other countries then the selected country. Something like this

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        7 years ago

        Should be able to use the same basic concept to create a flag variable. First, don't connect your slicer to your table. Then create a flag measure like:

         

        Measure Flag = 
VAR __selected = MAX('Table'[Column]) //value from slicer
RETURN
IF(MAX([Country]) = __selected,0,1)

        Filter on this measure.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous,

     

    Create a calculated table which lists all slicer selections. This table should be unrelated to source data table.

    slicerTable = VALUES('TB1'[Country])

    Add below measure to visual level filters, set its value to 0.

    check = IF(SELECTEDVALUE(slicerTable[Country])=SELECTEDVALUE(TB1[Country]),1,0)

    To calculate the price of selected country as a comparison, please create below measure.

    value for selected country = CALCULATE(SUM(TB1[Price]),FILTER(TB1,TB1[Country]=SELECTEDVALUE(slicerTable[Country])))

    Best regards,

    Yuliana Gu