topic Re: Two Measures required on same column based on different values in DAX Commands and Tips

Two Measures required on same column based on different values

PaisleyPrince — Sat, 14 Sep 2024 16:13:48 GMT

Hi,

I'm trying to create two measures based on slicer selections, which use the same column (location) as per below. The output would

be a matrix showing Description and total stock quantity for the first and second locations chosen (one measure for each). I have tried using SELECTEDVALUE as a filter for the measures but this throws an error. Any advice would be greatly appreciated.

thanks

Scott

Re: Two Measures required on same column based on different values

tamerj1 — Sat, 14 Sep 2024 18:34:16 GMT

Hi PaisleyPrince

use MAX

Re: Two Measures required on same column based on different values

PaisleyPrince — Sat, 14 Sep 2024 19:21:26 GMT

Hi, thanks for the advice - would you be able to elaborate ?

Re: Two Measures required on same column based on different values

Anonymous — Mon, 16 Sep 2024 09:29:20 GMT

Hi PaisleyPrince ,

Have a good day. Could you describe the desired output and share virtual sample data?

Best Regards,

Wearsky

Re: Two Measures required on same column based on different values

tamerj1 — Mon, 16 Sep 2024 19:02:32 GMT

PaisleyPrince

My guess is that you're using SELECTEDVALUE to retrieve the slicer selection of a parameter table. If this the case then you need to use MAX or MIN to retrieve that value instead of using SELECTEDVALUE which if used you'll receive an error.
If I guessed wrong then you're the one who needs to elaborate not me 😅

Re: Two Measures required on same column based on different values

PaisleyPrince — Mon, 16 Sep 2024 20:03:35 GMT

Hi,

I've attached sample input and output. tamerj1 is correct that i'm currently using SELECTEDVALUE.

Re: Two Measures required on same column based on different values

tamerj1 — Mon, 16 Sep 2024 20:32:01 GMT

PaisleyPrince

Why don't you just use a matrix visual? Description in the rows, Location in the columns and Stock quantity in the values. I hope you're not over simplifying the problem.

Re: Two Measures required on same column based on different values

Anonymous — Fri, 27 Sep 2024 05:39:02 GMT

Hi PaisleyPrince ,

As tamerj1's said, the matrix can meet your needs.

Best Regards,

Wearsky