Calculation

[aaditya2000]

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

[Zubair_Muhammad · Accepted solution]

Hi @aaditya2000

Try this MEASURE for CARD

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

[aaditya2000]

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

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