Forum Discussion
MohannadSh1996
Microsoft Employee
Microsoft EmployeeHaving both grouped and separated fields in a table
Is there a way to have both items grouped and seperated in a given table? Example: Device Android Windows Mac OS iOS Kingston What I need to have: Device Android ...
This can be done by creating a new column as a conditional or custom column after going to data transformation:
Then to union create a new table contains the unioned values from both original device column and the new extracted device:AllDevice = CALCULATETABLE(UNION(VALUES(Table[Device]),VALUES(Table[Device2])))
This new table (AllDevices) can be used as a slicer.
For filteration you may use this:FILTER(Table, OR(Table[Device] IN VALUES(AllDevices[Device]),Table[Device1] IN VALUES(AllDevices[Device]))
MohannadSh1996Microsoft Employee
Microsoft EmployeeMaybe we can do the following:
FILTER(Table1, OR(Table[Device] IN VALUES(AllValuesTable[Device]),ExtractedTable[Device] IN VALUES(AllValuesTable[Device]))
where AllValuesTable is the merged values between origianal and extracted table.
This solution worked for me
where AllValuesTable is the merged values between origianal and extracted table.
This solution worked for me
v-robertq-msft
Community Support
Community SupportHi, MohannadSh1996
Glad to hear that you have solved the problem by yourself, would you like to mark your own reply as a solution so that others can learn from it too?
Thanks in advance!
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- MohannadSh1996
I will add the whole solution before marking it as a solution