Forum Discussion

abukapsoun's avatar
abukapsoun
Post Patron
8 years ago
Solved

Measure not interacting

Hi,   I have the following case   Column 1     Column 2   Column 3 P1                  X                     name1 P2                  Y                     name2 P3                   X       ...
Need Help
  • TomMartens's avatar
    TomMartens
    8 years ago

    Hey,

     

    this sounds that the interactions are disabled. I creates a little table with you sample data, and if select "P3" from the column chart the table visual interacts as expected.

     

    Here is the code for my measure that counts the X in column2

    count X = 
CALCULATE(
	COUNTROWS('SimpleTable')
	,'SimpleTable'[Column2] = "X"
)

     

    Can you check the interaction settings:

    • mark your column chart
    • switch to the format menu and toggle the interaction mode

    I would expect that the filter symbol is shown above your table visual as shown in the screenshot

     

     

    Hope this helps

     

    Regards

    Tom

abukapsoun's avatar
abukapsoun
Post Patron
8 years ago

 

TomMartens

 

Yep Yep! now it worked. But visually I dont really like it. That way the release count will appear twice, once in the chart, and once in the table. Not that appealing :(

 

Is there any other way? or maybe can I hide these column from the table ? 

 

As for the formula I tried your and I tried the 'Count'

TomMartens's avatar
TomMartens
Super User
8 years ago

Hey,

 

here you find a little pbix file, look at the report page "Visual Interactions", I guess this is what you are looking for, but I have no idea what is different from your table model.

 

Regards

Tom