Forum Discussion

KnowNow's avatar
KnowNow
Helper I
2 years ago
Solved

Dynamic calculation for card visual

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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