Dynamic calculation for card visual

[KnowNow]

Hello,

I have a card visual with a measure that calculates a target goal. I also have a slicer with 3 different selections where each has a separate target goal. How can I make the card visual goal amount switch depending on the selection from the user. For example, the card visual shows a goal of $500k, the measure has this amount hardcoded in the calculation so when the user selects one of the 3 items from the slicer, the goal calculates this amount. I hope I am explaing this so someone can understand. The goal in the card at the top needs to change according to the slicer selection from the user.

                      Goal: $500K

                             20%

Current calc. Slicer selections: A, B, C

A = 100K/500k = 20%

B = 50K/500k = 10%

C = 150K/500k = 30%

New calc with changing goals. Slicer selections: A, B, C

A = 100k/250k

B = 50k/100k

C = 150k/500k

[Anonymous · Accepted solution]

Hi @KnowNow ,

If I understand correctly, the issue is that you want to dynamic calculations for card visual. Please try the following methods and check if they can solve your problem:

1.Create the Table and Table 2. 

2.Create a relationship with between Table[Selection] and Table 2[Name].

3.Move the Goal field into the card visual.

4.Create a measure that calculates the goal dynamically based on the slicer selection. Enter the following DAX formula.

Measure = DIVIDE(SUM('Table 2'[Value]),SUM('Table'[Goal]))

5.Move the measure into the card visual.

6.The result is shown below.

If the above ones can’t help you get it working, could you please provide more raw data(exclude sensitive data) with Text format or screenshot to make a deep troubleshooting? It would be helpful to find out the solution.

Looking forward to your replay.

Best Regards,

Wisdom Wu