topic Re: SWITCH AND SEVERAL VALUES to display in a card in DAX Commands and Tips

SWITCH AND SEVERAL VALUES to display in a card

Anonymous — Thu, 27 Apr 2023 14:19:31 GMT

I would like to know How is it possible to diplsay a value with a card when this one is selected in a filter?

I tried with the formula "Selectedvalue" but first, if nothing is selected then the value displays "(Vide)" whereas i would like to display something else in text. Second point, if we select 2 values, is is possible to display those ones?

Here is my exemple :

SWITCH(SELECTEDVALUE(Temps[Trimestre affichage]),"Trim 1","Trimestre 1","Trim 2","Trimestre 2","Trim 3","Trimestre 3","Trim 4","Trimestre 4","")

Several selection :

How can we do if we have several value ? Because here I have just 4 values but if i have more?

In add, if I select 2 values, it doesn't work (it displays nothing)

I don't know how is it possible to mix all that.

Thank you in advance for your return.

Léna

Re: SWITCH AND SEVERAL VALUES to display in a card

eliasayyy — Thu, 27 Apr 2023 15:02:35 GMT

Hello Lena,
Kindly follow my instruction

create a new measure

Semester Filtered = IF( ISFILTERED('Table'[Semester]), VAR _f = FILTERS('Table'[Semester]) VAR _d = CONCATENATEX(_f, SUBSTITUTE('Table'[Semester],"Trim","Trimester") ," , ") RETURN _d ,"Vide")

hope this helps if it does, a kudos and accept the solution would be appreciated

Re: SWITCH AND SEVERAL VALUES to display in a card

Anonymous — Fri, 28 Apr 2023 09:11:30 GMT

Hi eliasayyy , thank you for your explanations, it's very clear.

However, I have an other request to add in this formula. How can we add an other filter, for exemple, in drill down we can have "month".

So, if i select Trimester 1 then it displays Trimester 1 in the card. But if i select january then, it displays January and delete the Trimestre value in the card.

I played with the formula in different case but in vain.

Thank you a lot in advance and have a good day !

Léna

Re: SWITCH AND SEVERAL VALUES to display in a card

eliasayyy — Fri, 28 Apr 2023 09:27:45 GMT

hmmm can you please show me an example

Re: SWITCH AND SEVERAL VALUES to display in a card

Anonymous — Fri, 05 May 2023 10:47:46 GMT

Hi eliasayyy ,

Sorry for being late,

Of course I can , here I select trimester + month :

But, If I do this, it shows in he card this result :

The best result it's if we can display only the month. On the contrary, if I select all trimester, then it displays "Trimester 1" if not "January" (or January & February). Etc.

I hope i am clear 🙂

Thank you in advance,

Léna