topic Re: DAX - Selected value in DAX Commands and Tips

DAX - Selected value

Prabha45 — Thu, 02 Mar 2023 06:09:55 GMT

Hi
I wrote a measure where if is January is selected measure shows 1, february 2, so on till december.
Measure = switch(selectedvalue
(dim_table[month_name]),
"January",1,
"February",2)
Is it possible , if both January and February are selected, measure should show 1,2. If January,February and March are selected measure should show 1,2,3.

Thankyou

Re: DAX - Selected value

FreemanZ — Thu, 02 Mar 2023 06:22:10 GMT

hi Prabha45

1) try to add a column like:

month_number = SWITCH( [month_name], "January", 1, "February", 2, "March", 3, "April", 4, "May", 5, "June", 6, "July", 7, "August", 8, "September", 9, "October", 10, "November", 11, 12 )

2) then plot a measure like this:

Measure = CONCATENATEX( TableName, TableName[month_number], "," )

it worked like:

Re: DAX - Selected value

tamerj1 — Thu, 02 Mar 2023 06:48:45 GMT

Hi Prabha45

if the month name column is coming from a date table the you can try.

CONCATENATEX ( VALUES ( 'Date'[Date].[Month] ), [Month], "," )

However, the following shall work in all scenarios

CONCATENATEX (

VALUES ( 'Table'[Month] ),

SWITCH (

[Month],

"January", 1,

"February", 2,

etc.

","

)

Re: DAX - Selected value

Prabha45 — Thu, 02 Mar 2023 06:51:45 GMT

Thanks that worked. But, the measure is in Text format. I used convert to change it to integer then the output changed to 123.

Re: DAX - Selected value

Prabha45 — Thu, 02 Mar 2023 07:01:53 GMT

Thanks that worked. I need the measure to be in integer format, but it is in Text format. I used convert to change it to integer then the output changed to 123.

Re: DAX - Selected value

FreemanZ — Thu, 02 Mar 2023 07:13:46 GMT

hi Prabha45

why change to integer?

Re: DAX - Selected value

tamerj1 — Thu, 02 Mar 2023 07:18:34 GMT

Prabha45

Cannot have an integer with delimiter. What exactly are you trying to achieve?

Re: DAX - Selected value

Prabha45 — Thu, 02 Mar 2023 07:29:16 GMT

I need to trigger a function app with the filters selected in Power BI as input for the function app. It has month parameter which accepts inputs as 1 or 1,2 or 1,2,3. If I use the above measure( text format) it takes the values as "1,2,3". So, I converted it to integer then it took input as 123.

Re: DAX - Selected value

Prabha45 — Thu, 02 Mar 2023 07:41:47 GMT

Re: DAX - Selected value

tamerj1 — Thu, 02 Mar 2023 08:23:02 GMT

Prabha45

So with CONVERT you got your desired outcome? Or you still need further support? If so please clarify further perhaps with some examples and/or screenshots.

Re: DAX - Selected value

Prabha45 — Thu, 02 Mar 2023 08:30:14 GMT

No. If I use convert, the output of the measure changes to 123. With 123 as input, I can't trigger the function app.
If I don't use convert, the measure output is 1,2,3. when I pass this as input it takes as "1,2,3".

Re: DAX - Selected value

tamerj1 — Thu, 02 Mar 2023 09:09:52 GMT

Prabha45

I hope you realize that there is no possibility that I have any idea what function app is. I don't see what you see. I have no access to your report so please treat me as complete blind when explaining to me ☺️