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

Hi Anonymous,

If these card visuals calculate based on different filter interactions, you can't direct calculate between them.
For this scenario, you need to manually write calculate expressions to restore the filter effects of two calculations then you can get the different them.

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Xiaxin, 

thank you. Could you please advise, how to manually write calculate expressions to restore the filter effects? I can google forward, but I dont know what for now :). Thank you.