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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I dont understand - when all filters interact, I see only data, that corespond with them - so in the case on the picture, none. Is it possible somehow define in measure, that it shall take that number shown on the card?

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

Hi again , 

Can you share a example with dummy values? 

 

BR 

Bruno

  • onurbmiguel_'s avatar
    onurbmiguel_
    Icon for Power Participant rankPower Participant
    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Bruno, that is perfect! Thank you! 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Bruno, 

     

    yes, I would like to. How can I share? I cannot upload .pbix file directly here. 

    Thank you.

     

    BR

    Kristýna

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Bruno, 

     

    if it is ok, there is a link to the file: https://sendy.link/9GKAWONN.

    Thank you.

     

    BR

    Kristýna