The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 .
User | Count |
---|---|
17 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
9 | |
8 |