Forum Discussion

aaditya2000's avatar
aaditya2000
Helper II
8 years ago
Solved

Calculation

Hello:

 

I need help on the calculation part & how do?

 

I want to display total dollars amount on CARD which is based on A & B.

 

(A) Tabble 1 meassure = Remote Saving

Remote Saving = COUNTROWS(FILTER(Table1,
(Table1[col1] = "N" && Table1[col4] = "N")))

 

This gives for e.g. Remote Saving = 80

 

(B) Table 2 is look up table of 9 dollars values (100,150,200,250,300,350,400,450,500)

      SLICER has values from Table 2

 

Based on value selected in SLICER, CARD should display calculated value accordingly.

 

for e.g. if i select value 100 from SLICER then CARD should display value $8000 (100 * 80)

            if i select value 150 from SLICER then CARD should display value $12000 (150 * 80)

 

I need help how to achive above from SLICER, any help is greatly appreciated.

 

Thank you in advance.

Thanks

 

 

 

 

 

 

2 Replies

    • aaditya2000's avatar
      aaditya2000
      Helper II

      Thank you Zubair, it worked with minor modification but SELECTEDVALUE was key for resolution.

       

      MEASURE = CALCULATE(
       [Remote Saving] * SELECTEDVALUE (Table2[Slicer Column])
      )