The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
HI
I have a slicer and want to use selected value to a card measure multiplication.
My card value will be measure = slicer selected value * qty member * 5
Is that possible?
My slicers values are on table "PROPOSTA'".
Thanks for help.
Solved! Go to Solution.
Hi @AleMacedo ,
G1VALUE = CALCULATE( SELECTEDVALUE(PROPOSTA1[RECEBIMENTO MÉDIO PROPOSTO PROPOSTO])*MAX(PROPOSTA1[Total Recebimentos])*5 , FILTER(PROPOSTA1 , PROPOSTA1[GRUPO] = "GRUPO 1 - ATÉ 39 ANOS")
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
HI @AleMacedo ,
Use the following measure
hi
It did work great for me like this:
But I need todo it with filter in 'PROPOSTA1[GRUPO] with"GRUPO 1 - ATÉ 39 ANOS".
Is that possible to add this filter to formula?
thanks a lot for help.
Hi @AleMacedo ,
G1VALUE = CALCULATE( SELECTEDVALUE(PROPOSTA1[RECEBIMENTO MÉDIO PROPOSTO PROPOSTO])*MAX(PROPOSTA1[Total Recebimentos])*5 , FILTER(PROPOSTA1 , PROPOSTA1[GRUPO] = "GRUPO 1 - ATÉ 39 ANOS")
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Perfect!! Thank you!!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
32 | |
20 | |
17 | |
15 |
User | Count |
---|---|
53 | |
31 | |
30 | |
23 | |
21 |