topic Re: Selected value on Dax in switch in DAX Commands and Tips

Selected value on Dax in switch

Elglouton — Tue, 06 Aug 2024 14:26:53 GMT

Hello,

I use the value captured by the Selectedvalue function as a variable to perform standard calculations, it works perfectly, but I wanted to embed it in a switch and the function returned the alternatResult.

parameter table

Boites Max = GENERATESERIES(500,500000,100)

Value

Valeur Boites Max = SELECTEDVALUE('Boites Max'[Boites Max],0)

SWITCH fonction

BoiteJourPrev_L1 = SWITCH (

T_DATE_[JoursVacances],

False,[Valeur Boites Max],0

)

Same with

BoiteCumulPrev_L1M2 =

CALCULATE(

TOTALMTD(

([Valeur Boites Max]),T_DATE_[Date],T_DATE_[JoursVacances]=False())

)

I use this measure to write the value to the table if the date is worked on

Re: Selected value on Dax in switch

Wilson_ — Tue, 06 Aug 2024 18:05:53 GMT

Hi Elglouton,

It's unclear to me from your measure syntax what you're trying to accomplish. For example, your BoiteJourPrev_L1 measure looks like it's missing something and doesn't make sense logically. Check out this documentation on SWITCH and see if it helps.

If you're still having trouble, please explain in words what you're actually trying to calculate in your two measures.

Re: Selected value on Dax in switch

Elglouton — Wed, 07 Aug 2024 05:26:25 GMT

Hello
thank you for your reply.
In my company we make boxes and we have a minimum quantity of boxes to produce per day to be in the forecast. I monitor this via a monthly graph which compares the boxes to be made with the boxes made.
But depending on the forecast this quantity changes from month to month and I would like to be able to use a segment so that the report users can change it easily.

so I have a segment

and I want to use the selected value of this segment
Valeur Boites Max = SELECTEDVALUE('Boites Max'[Boites Max],0)

to make a monthly accumulation only of the days worked which are given by JoursVacances=True

I haven't managed to do it directly, so I'm going through an intermediary.

BoiteJourPrev_L1 = SWITCH (
T_DATE_[JoursVacances],
False,[Valeur Boites Max],0
)

then I do my accumulation

BoiteCumulPrev_L1M =
CALCULATE(
TOTALMTD(
sum(T_DATE_[BoiteJourPrev_L1]),T_DATE_[Date],T_DATE_[JoursVacances]=TRUE())
)

When I use it in simple calculations it works and I get back the value of the segment but when I want to integrate it in BoxDayPrev_L1 the calculation works but with the value alternatResult of SELECTEDVALUE()

I hope this is clearer
I'm new to PWBi and I'm probably not using the different functions in the right way and I apologise for that.

Re: Selected value on Dax in switch

Wilson_ — Wed, 07 Aug 2024 13:11:18 GMT

Hi Elglouton,

Thanks for elaborating. I think I understand now. Can you also share a screenshot of your data model? I have an idea of what you need but it depends on your tables and relationships.

Re: Selected value on Dax in switch

Elglouton — Wed, 07 Aug 2024 13:25:09 GMT

Hello,

perfect if it's easier to understand...
All is in the same table here attached a screen hoping that it is enough

Re: Selected value on Dax in switch

Wilson_ — Thu, 08 Aug 2024 13:10:17 GMT

Elglouton,

In that case, please try:

BoiteCumulPrev_L1M = VAR NumDays = CALCULATE ( COUNTROWS ( VALUES ( T_DATE_[Date] ) ), -- counting the number of days T_DATE_[JoursVacances] = TRUE(), -- where JoursVacances is True DATESMTD ( T_DATE_[Date] ) -- and days are in month to date ) VAR Result = NumDays * [Valeur Boites Max] -- multiplying number of days by your selected value RETURN Result

No need for the other intermediary measure, unless you want to reuse it for other measures as well. (I also think based on your screenshots that you meant that T_DATE_[JoursVacances] should be TRUE? It's confusing because the screenshot is saying vacation days are the ones that you're assigning the 7,500. Either T_DATE_[JoursVacances] should be TRUE or the True/False in the screenshot is backwards - or I've misunderstood that part too. :D)

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.

Re: Selected value on Dax in switch

Elglouton — Thu, 08 Aug 2024 13:45:39 GMT

Hello
thank you for your answers and your time

in fact the title does not correspond to the result but the error is correct, I have written incorrectly and never changed the title but I must accumulate the days worked.

Your function code saves me the intermediate calculation if I use fixed data for ([Max Boxes Value])

but unfortunately does not solve my problem.

if I use ([Max Box Value]) which is variable data entered from the max box segment it doesn't work.

Segement

Re: Selected value on Dax in switch

Wilson_ — Thu, 08 Aug 2024 17:43:12 GMT

Elglouton,

Can you please share a sample pbix file? (If you don't know how, please check the pinned thread in the forum.)

My measure should be using the parameter value you're showing in the second screenshot.

Re: Selected value on Dax in switch

Elglouton — Fri, 09 Aug 2024 07:49:30 GMT

Hello,

Attached is a link to a simplified file Fichier simplifié

the value taken into account is the default value of the segment but not the value entered in the segment.

Thanks

Re: Selected value on Dax in switch

Wilson_ — Fri, 09 Aug 2024 20:38:51 GMT

Elglouton,

Ah, it looks like the issue is you added it as a calculated column. It should be a measure.

P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.

Re: Selected value on Dax in switch

Elglouton — Mon, 12 Aug 2024 09:26:35 GMT

Hello,

Halala, in fact, it was that simple.

I didn't think I could make a graph with a measure because for me it's a unique value.

Sorry for the time you spent on this topic and thanks again

Re: Selected value on Dax in switch

Wilson_ — Mon, 12 Aug 2024 14:22:29 GMT

You're welcome, Elglouton. That's what we're here for! 😄

Thanks for the update.