Forum Discussion
How to Capture Individual Numbers in Dynamic Arrays per Cell
Good day, I would like to ask if Power BI can capture the individual IDs in an entry with a dynamic count of ID values in an entry: Operator Shift 1 1 1,2 2 1,3,5 1 2 2 ...
I tried splitting the values, but being in DirectQuery mode, I was unable to do so. What we did instead was we separated the Operators into multiple tables. Here is the schema of the tables:
The mainID of the Main table has active one-to-one connections with the different Operator[x] tables. As such, I cannot create active many-to-one connections from the different Operator[x] tables using the OperatorID to the Operator table. Currently, the relationships are set to inactive, and I am supposed to filter out the name of the specifically selected operator.
Is there a way by DAX for me to filter the said table as I am using Directquery?
Thanks,
Nico