Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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 , 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])
Thanks Amit!
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |