Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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])
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |