topic Re: Measure to return a specific value in a column based on slicers in DAX Commands and Tips

Measure to return a specific value in a column based on slicers

KH88 — Tue, 16 May 2023 20:56:52 GMT

Hi all,
I'm struggling to create a measure. I have a data table that lists products, their associated tests, and the spec limits for each test. My Power BI page is set up with slicers for both product and test. The idea is to create a multi-row card that would list the spec limits (min, target, max) and would change for the associated product and test every time the slicers were changed. I cannot figure out how to do this with a measure and have it pull the value I need specific to the slicer-selected product and test. I tried using SELECTEDVALUE('Product Specs'[Target]) but that returns [BLANK], I assume because it's not filtering down to one value like I think.

Table: Product Specs

Product	Test	Min	Target	Max
Cheese	Fat	1	3	6
Cheese	Protein	10	12	16
Milk	Fat	2	3	4
Milk	Protein	7	9	12
Milk	Moisture	80	85	90

Any help is appreciated! Thanks!

Re: Measure to return a specific value in a column based on slicers

Greg_Deckler — Tue, 16 May 2023 21:12:11 GMT

KH88 You could use any simple aggregation for this I believe. See attached PBIX file below signature.

Re: Measure to return a specific value in a column based on slicers

KH88 — Wed, 17 May 2023 15:52:19 GMT

Thank you. I thought it should be that simple but it wasn't giving me the right answer. Digging into it more, it looks like my table connections for the Test ("product" and "test" slicers aren't pulling directly from that table but route through other connections to compile multiple ways that "test" can be represented in the data) were not connected correctly so it was summing all of the values instead of going through the test slicer. I'm glad to hear it's as simple as that once I get my connections fixed.