Forum Discussion

dhoefler's avatar
dhoefler
Regular Visitor
8 years ago

dynamic columns based on slicer selections

I have 2 table charts each with their own slicers for the user to select year, month and customer. I need a third table that will dynamically show the difference between the 1st and 2nd table values ...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

dhoefler,

Create a measure using DAX below in the first table, then drag the measure to Card visual. If the dax doesn't help, please share dummy data of the two  tables and post expected result here.

DiffMeasure = SUM(Table1[column])-SUM(Table2[Column])

Regards,
Lydia

dhoefler's avatar
dhoefler
Regular Visitor
8 years ago

Thank you for the suggestion but not quite what I needed. I have 2 table graphs each with its own independent slicers. The 3rd table graph needs to dynamically figure the variance based on the slicers. 

 

In the example below, I am expecting to see Segment = Covenience, Units = 32.890, Revenue = 22,524,699.03. Essentially, take the difference between the values in the 2 table charts, based on slicer selection, and display that in the 3rd table chart.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    dhoefler,

    Please share dummy data of the three tables, and describe the relationship among them.

    Regards,
    Lydia