Measure Interaction not working

Hi, Anonymous 

I think the solution suggest by @Greg_Deckler is correct. As is mentioned in the last post, 'When I click on the clustered bar chart(TNB) the TB and Count of Task should be 2 but they are not interacting. ', I assume that you want to filter another measure with a clustered bar chart which is a measure. It is unavailable to interact like above. There is no column on 'Axis' in the bar chart.

I created data to reproduce your scenario. Here are the measures.

Count of Distinct Orders = 
  var __Table =
    GROUPBY(
      'Table',
      [Order No],
      "Balance",SUMX(CURRENTGROUP(),[Order/Task Quantity])
    )
var _re = 
  COUNTROWS(__Table)
return
IF(
    ISBLANK(_re),
    0,
    _re
)
Count of Orders in Balance = 
  var __Table =
    GROUPBY(
      'Table',
      [Order No],
      "Balance",SUMX(CURRENTGROUP(),[Order/Task Quantity])
    )
var _re = 
  COUNTROWS(FILTER(__Table,[Balance]=0))
return
IF(
    ISBLANK(_re),
    0,
    _re
)
Count of Orders not in Balance = 
  var __Table =
    GROUPBY(
      'Table',
      [Order No],
      "Balance",SUMX(CURRENTGROUP(),[Order/Task Quantity])
    )
var _re = 
  COUNTROWS(FILTER(__Table,[Balance]<>0))
return
IF(
    ISBLANK(_re),
    0,
    _re
)
Count of Distinct Tasks = 
  var __Table =
    GROUPBY(
      'Table',
      [Task Order No],
      "Balance",SUMX(CURRENTGROUP(),[Order/Task Quantity])
    )
var _re = 
  COUNTROWS(
      FILTER(
          __Table,
          [Task Order No]<>BLANK()
      )
  )
return
IF(
    ISBLANK(_re),
    0,
    _re
)
Count of Tasks in Balance = 
  var __Table =
    GROUPBY(
      'Table',
      [Task Order No],
      "Balance",SUMX(CURRENTGROUP(),[Order/Task Quantity])
    )
var _re = 
  COUNTROWS(
      FILTER(
          __Table,
          [Task Order No]<>BLANK()&&
          [Balance]=0
      )
  )
return
IF(
    ISBLANK(_re),
    0,
    _re
)
Count of Tasks not in Balance = 
  var __Table =
    GROUPBY(
      'Table',
      [Task Order No],
      "Balance",SUMX(CURRENTGROUP(),[Order/Task Quantity])
    )
var _re = 
  COUNTROWS(
      FILTER(
          __Table,
          [Task Order No]<>BLANK()&&
          [Balance]<>0
      )
  )
return
IF(
    ISBLANK(_re),
    0,
    _re
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.