DAX to create Pivot Table

[Jimmy_hu]

I would like to create a new Pivot Table, What DAX can make it

Orig Table

Device	Software
a	s1
a	s2
b	s1

Pivot Table

Device	s1	s2
a	TRUE	TRUE
b	TRUE	FALSE

[v-yetao1-msft · Accepted solution]

Hi @Jimmy_hu 

You can create a calculated table to return the table you want .

New Table =
var _summar=SUMMARIZE('Table','Table'[Device], "combine", CONCATENATEX('Table',[Software],","))
var _t=ADDCOLUMNS(_summar,"s1",IF(CONTAINSSTRING([combine],"s1"),TRUE(),FALSE()), "s2",IF(CONTAINSSTRING([combine],"s2"),TRUE(),FALSE()))
return SUMMARIZE(_t,[Device],[s1],[s2])

The final result is as shown :

I have attached my pbix file , you can refer to it .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jimmy_hu]

Yes, works perfect. Thand you very much

[tamerj1]

Hi @Jimmy_hu 

Meaure = NOT ISBLABK ( Table[Software] ]