Forum Discussion

chrisgehm's avatar
chrisgehm
Icon for Helper III rankHelper III
9 years ago
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?...
Need Help
  • TomMartens's avatar
    TomMartens
    9 years ago

    Hey,

     

    try this

    the measure = 
DIVIDE(
  CALCULATE(
    ,COUNTROWS('yourtable')
    ,'yourtable'[colorcolumn] = "red"
  )
  ,CALCULATE(
    ,COUNTROWS('yourtable')
    ,'yourtable'[colorcolumn] = "blue"
  )
)

    Regards

    Tom

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
9 years ago

Hey,

 

try this

the measure = 
DIVIDE(
  CALCULATE(
    ,COUNTROWS('yourtable')
    ,'yourtable'[colorcolumn] = "red"
  )
  ,CALCULATE(
    ,COUNTROWS('yourtable')
    ,'yourtable'[colorcolumn] = "blue"
  )
)

Regards

Tom

LarBo's avatar
LarBo
Frequent Visitor
6 years ago

Hi TomMartens  thank you for your answer, but what happens if red and blue values are not fixed, but ther are selected in two different selection box?

 

Is any option to do the same dinamically?

 

Thank you