Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Measure Interaction not working

Hello All,   Below is the link to the dataset and I tried below DAX to calculate Count of Orders in Balance. The numbers seems are fine but visuals are not interacting. https://community.powerbi.c...
Need Help
Show and Tell
Tutorial Requests
VijayP's avatar
VijayP
Community Champion
6 years ago

Anonymous 

 

In the Countrow function, before the last ")", use VALUES(Context of filter) then it should work

Anonymous's avatar
Anonymous
Not applicable
6 years ago

VijayP 

Thanks for the reply. I tried below and got this error.

The VALUES function expects a column reference expression or a table reference expression for argument '1'

Count of Orders in Balance =
  VAR __Table =
    GROUPBY(
      'Table',
      [Order No],
      "Balance",SUMX(CURRENTGROUP(),[Order/Task Quantity])
    )
RETURN
  COUNTROWS(FILTER(VALUES(__Table),[Balance]=0))