Forum Discussion

aaditya2000's avatar
aaditya2000
Icon for Helper II rankHelper 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 = COUNTRO...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi aaditya2000

     

    Try this MEASURE for CARD

     

    MEASURE =
SELECTEDVALUE ( Table2[Slicer Column] ) * [Remote Saving]
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi aaditya2000

 

Try this MEASURE for CARD

 

MEASURE =
SELECTEDVALUE ( Table2[Slicer Column] ) * [Remote Saving]
aaditya2000's avatar
aaditya2000
Icon for Helper II rankHelper II
8 years ago

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

 

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