Filter Without Related Values

[Anonymous]

Hi,

I have a calculated field that multiplies sumed values from 2 seperate tables. 

Calculated_Field= sum(TableA[Bookings])*sum(TableB[Decimal_Number]) = 15

I would like to take this calculated field, and put it inside a matrix where the row values are from a third table. None of these tables have related values that can be used to create a relationship. However, I want my calculated field (it's static at 15) to only display for  certian values in table C (as displayed below). Is there a way to do this.

TableC[Market]

Market                |  Calculated Field

__________________|__________________

North America    |      15

Europe                |        0

South America    |       15

Asia                     |       0

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

Yes, you could get it by the logic of this formula

Measure= IF( SELECTEDVALUE(TableC[Market])="North America", SUM(Calculated_Field),
             IF(SELECTEDVALUE(TableC[Market])="South America" , SUM(Calculated_Field),
               0)
           )

Best Regards,

Lin