Forum Discussion
Helper IISelect all the value in a visual table column
Hello all,
I have a page with two tables in my report and I would like to filter the bottom table with only the contracts that are present in the top table.
I know that I can select the contracts in the top table with CTRL+Click but I'd like it to be automatic.
Here is exactly how it works :
First, I have this visual table in my report, Value 1, Value 2 and Diff are measures :
The second visual table in my report is quite the same but with a dimension "Origin" which separate my rows :
I created a button to filter the first visual table to show only diff <> 0, which give me that :
What I'd like to have is that the bottom visual table filtered on only the contracts in the top one after filtered on diff <> 0, but I cannot apply the diff <> 0 filter because of the "Origin" dimension (the diff is always <> 0) :
Do you have a tips to do this type of operation?
Thank you in advance.
1 Reply
- amitchandak
Super User
Tybaal , Try measure like
new value 1 =
calculate([value1], filter(Table, calculate([Value1] -[value2], filter(all(Table), Table[contract] =max(Table[Contract]))) <> 0 ))
New Value 2 =
calculate([value2], filter(Table, calculate([Value1] -[value2], filter(all(Table), Table[contract] =max(Table[Contract]))) <> 0 ))
New diff =
calculate([Diff], filter(Table, calculate([Value1] -[value2], filter(all(Table), Table[contract] =max(Table[Contract]))) <> 0 ))
