Forum Discussion

MohannadSh1996's avatar
MohannadSh1996
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago
Solved

Having 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 ...
Need Help
Tips and Tricks
  • MohannadSh1996's avatar
    MohannadSh1996
    5 years ago

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


MohannadSh1996's avatar
MohannadSh1996
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

I  have a big size data that I don't think it is fine to duplicate it.
But maybe we can extend just the Device values table to include new two items windows, mac os and group them while keeping the original ones.

 

BTW, How to duplicate these specific two values? 

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
5 years ago

to duplicate the values, you will can create two columns where one is as it is and the other one, you sub with desktop. then unpivot them.

Device Device1 Device2
Android Android Android
Windows Windows Desktop
Mac OS Mac OS Desktop
iOS iOS iOS
Kingston Kingston Kingston

like this, then unpivot device1 and device2.

 

hope this helps!