Forum Discussion

Icon for Helper I rank

Helper I

6 years ago

Solved

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.

measure based on slicer

Anonymous
6 years ago
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)

4 Replies

Anonymous
Not applicable
6 years ago
HI AleMacedo ,

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)
- AleMacedo
  Helper I
  6 years ago
  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.
  - Anonymous
    Not applicable
    6 years ago
    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)

Related content