How to create a pivot table where the same field is in rows and columns but with different filters?

[dancarr22]

Hello,

We have a PBI data model with 2 tables:

(1) A table of processes - each has a unique ID called Process ID.  i.e. Process ID 1 = Load food price data from Vendor X.  So, 2 pieces of data associated with this "Price Data" and "Vendor X"

(2) A table of tags associated with the processes in (1).  So, we have 2 records associated with ID 1.  Tag 1 (Dataset) = "Price Data" and Tag 2 (Vendor) = "Vendor X"

Process ID	Tag ID	Tag Type	Tag Value
1	1	Dataset	Price Data
1	2	Vendor	X

We want to create a pivot table in PBI where we have columns be Vendor and rows be Dataset - so we can see the combination of what every vendor sends us.  But, we cannot filter the fields separately since they're in the same table.  Thoughts on how to accomplish this?

Thanks!

Dan

[amitchandak · Accepted solution]

@dancarr22 , Based on what I got so fare you have create measures

Of handle condition in a measure

M1= Switch(True(),

Max(Table[tags]) = "A"  && Max(Table[Vendor] ) = "Vendor X", [Value],

[Value2]

)

You can correct the sum as

Sumx(Summarize(Table, Table[Process ID]), [M1])

[dancarr22]

Thanks Amit!