Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi @aaditya2000
Try this MEASURE for CARD
MEASURE = SELECTEDVALUE ( Table2[Slicer Column] ) * [Remote Saving]
Hi @aaditya2000
Try this MEASURE for CARD
MEASURE = SELECTEDVALUE ( Table2[Slicer Column] ) * [Remote Saving]
Thank you Zubair, it worked with minor modification but SELECTEDVALUE was key for resolution.
MEASURE = CALCULATE( [Remote Saving] * SELECTEDVALUE (Table2[Slicer Column])
)
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |