Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AleMacedo
Helper I
Helper I

Slicer selected value used in formula

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.

1 ACCEPTED 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)

 

 

View solution in original post

4 REPLIES 4
harshnathani
Community Champion
Community Champion

HI @AleMacedo ,

 

1.jpg2.JPG

 

Use the following measure

 

Card Value = SELECTEDVALUE(Proposta[Slicer Value]) * MAX(Proposta[Quantity]) * 5
 
 
Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

hi

 

It did work great for me like this:

G1VALUE = SELECTEDVALUE(PROPOSTA1[RECEBIMENTO MÉDIO PROPOSTO PROPOSTO])*MAX(PROPOSTA1[Total Recebimentos])*5

 

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!!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors