Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Comparison with SIblings

Hi,   Need your help in solving which looks like a simple problem.   I have below dataset   City Store  Revenue London L-Store 1 100 London L-Store 2 150 Sydney S-Store 1 ...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks Zubair for your help.

 

Would it be possible to do without a calculated table, on the original table.

As every new table in the model would require the relationships to be build. 

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    8 years ago

    HI Anonymous

     

    I think it is not possible because a slicer from the same table will filter the values selected.

     

    But may be there is a way I am not aware of.

     

    Nevertheless, you do not need to establish relationship between calculated table and your datamodel.

    In my example, i did not create any relationship

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Zubair,

       

      I did notice that there was no relationship between tables.

       

      However that Store filter is a global filter , filtering other visuals as well on the report. It wont be possible to add another Slicer coming from calculated table

       

      Thankg again for your help.