Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
i have 5 columns each values are unique vlaues . i have one column DOM Filter . DOM filter have combine value and also seperate value . i have attached sample date for reference
Code Value 1 value 2 value 3 DOM
101 5 10 7 A104
101 5 10 7 B104,S104,A104
101 5 10 7 Z104,R104
101 5 10 7 G104,A104
101 5 10 7 O104
101 5 10 7 R104
101 5 10 7 S104,Z104
I have seperate sheet for DOM filter
DOM Filter
A104
B104
Z104
O104
G104
R104
S104
If i select value A104 in filter value should come from combine value and seperate value . like
VALUE 1 VALUE 2 VALUE 3
A104 15 30 21
any idea ? thanks in advance .