Forum Discussion
How to sum two cards
- 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
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
BC
Yeh, 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_4 years ago
Power Participant
Hi again
Is it always the currente month and the previous?
BR
Bruno
- Anonymous4 years agoNot applicable
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_4 years ago
Power Participant
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