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 EmployeeThis 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:
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]))