Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to sum two cards

Dear all,  is it possible, to sum two cards? I have two cards, each one representing result from table.  - Card A sums a column from table A with date and personal filters - Card B sums a column f...
Need Help
Tips and Tricks
  • onurbmiguel_'s avatar
    onurbmiguel_
    4 years ago

    Hi again

    something like that? 

    creat this new measure please: 

     

    New_Measure = 
CALCULATE(
    sum(Order_rewards[reward_mediated_for_validator]),
    REMOVEFILTERS(Date_validated)
)
+
CALCULATE(
    sum(Validated_per_day[reward]),
    REMOVEFILTERS(Date_mediated)
)

     

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
    Best Regards
    BC

onurbmiguel_'s avatar
onurbmiguel_
Icon for Power Participant rankPower Participant
4 years ago

Hi again

Is it always the currente month and the previous? 

 

BR 

Bruno 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, no, not always. The user might use the filters differently - same months too. In the person filter he can also choose more than 1 person. 

 

  • onurbmiguel_'s avatar
    onurbmiguel_
    Icon for Power Participant rankPower Participant
    4 years ago

    HI again, 

     

    The filters on the top filters card A and the filters on the botton filters card B is that? 

    You have remove interation ? 

     

    BR 

    Bruno 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi, exactly, the red filters are for A and the blue filters on bottom are for B and I removed the interaction between the filters and of the filters to the table. 

      • onurbmiguel_'s avatar
        onurbmiguel_
        Icon for Power Participant rankPower Participant
        4 years ago

        Hi again

        Try to creat a card here all filters will interact. 

         

        BR 

        Bruno