Forum Discussion

chrisgehm's avatar
chrisgehm
Helper III
8 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
    8 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
Super User
8 years ago

Hey,

 

try this

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

Regards

Tom

bull123456789's avatar
bull123456789
Frequent Visitor
6 years ago

Hi Tom

 

Thanks for this. I've spent too long trying to get this result until I found your messaure!

 

One thing, for me the mesaure only worked when I took out the commas (in Red below): 

 

the measure =
DIVIDE(
CALCULATE(
,COUNTROWS('Table20')
,'Table20'[Status Fixed] = "Disengaged"
)
,CALCULATE(
COUNTROWS('Schedule20')
,'Table20'[Status Fixed] <> BLANK()
)
)*100

 

Any thoughts why this might be? 

 

Thanks 

Duncan