Forum Discussion

Crazydog's avatar
Crazydog
Frequent Visitor
3 years ago
Solved

Slicer & value pick

So I have say 3 columns,    (num)Col A     (num)Col B       (num)Col C (Calculated = Col A * Col B)  0.5                   2                           0.5 * 2    7                      5        ...
Need Help
Show and Tell
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, Crazydog ;

    May be you need add a new table from column2,

    Table 2 = VALUES('Table'[Column2])

    Then you could create a measure,

    column3 = SUM('Table'[Column1])*MAX('Table 2'[Column2])

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, Crazydog ;

May be you need add a new table from column2,

Table 2 = VALUES('Table'[Column2])

Then you could create a measure,

column3 = SUM('Table'[Column1])*MAX('Table 2'[Column2])

The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.