Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there - referencing the example data above, I'm trying to create the 'desired output' as a dashboard visual using measures (instead of PowerQuery or calculated columns).
I started with this measure:
HasSPCC = LOOKUPVALUE(Plans[PlanTypeCode],Plans[FacilityId],SELECTEDVALUE(Facilities[FacilityId]))
Translated to English, I'm Facilities [FacilityID] within Plans [FacilityID] column and returning result Plans [PlanTypeCode].
I get this error: "ERROR: A table of multiple values was supplied where a single value was expected."
I assume it's because Plans [FacilityID] is not unique (there can be several different plans for each facility - see yellow highlights).
Based on that, I assumed that wrapping the measure in a CALCULATE function would work. I tried these two, with no luck:
Solved! Go to Solution.
Hi @tomascid
create a relationship between the two tables. Use a matrix visual.. place Facilities[Facility ID] in the rows of the matrix. Place Plans[PlanTypeCode] in the columns of the matrix and place the following measure in the values of the matrix
Count = COUNTROWS ( Plans )
Solved! https://community.powerbi.com/t5/Desktop/LookupValue-with-Filter/td-p/993672
Just need to use the second lookup parameters of LOOKUPVALUE:
Hi, @tomascid
You can try the following methods.
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @tomascid
You can try the following methods.
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Solved! https://community.powerbi.com/t5/Desktop/LookupValue-with-Filter/td-p/993672
Just need to use the second lookup parameters of LOOKUPVALUE:
Hi @tomascid
create a relationship between the two tables. Use a matrix visual.. place Facilities[Facility ID] in the rows of the matrix. Place Plans[PlanTypeCode] in the columns of the matrix and place the following measure in the values of the matrix
Count = COUNTROWS ( Plans )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |