Forum Discussion
How to sum two cards
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
Power ParticipantHello Dohaje
Try to creat a new measure
new_measure = [measure_card A] + [measure_card B]
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
Best Regards
BC
Hi, thanks, could you please advise, how to define the measure_card A? In the card A, it is just a column from a table. Thank you.
- onurbmiguel_
hi again,
Is it a simple measure? Try:
1) # of A = sum(column A)
2) # of B = sum(column B)
3) # of total =sum(column A) + sum(column B)
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
Best Regards
BCYeh, thats exactly, what I have. As you can see, column A is for September and column B for August. So the result of that measure wouldnt be 9650,- as I need, but 0, because the measure will apply all the filters. So I am looking for a solution, where I wouldnt sum the columns, but the cards, the numbers, they show wright now.
- onurbmiguel_
Hi again
Is it always the currente month and the previous?
BR
Bruno