Forum Discussion
Solved
Operate with 2 cards
Hi everyone! I'm having troubles while operating with 2 cards. Both of them have filters and I have a numer from each card. Is there any way to make arithmetic operations between both cards?...
Hey,
try this
the measure = DIVIDE( CALCULATE( ,COUNTROWS('yourtable') ,'yourtable'[colorcolumn] = "red" ) ,CALCULATE( ,COUNTROWS('yourtable') ,'yourtable'[colorcolumn] = "blue" ) )Regards
Tom
Hey,
try this
the measure =
DIVIDE(
CALCULATE(
,COUNTROWS('yourtable')
,'yourtable'[colorcolumn] = "red"
)
,CALCULATE(
,COUNTROWS('yourtable')
,'yourtable'[colorcolumn] = "blue"
)
)Regards
Tom
