Need help

[Anonymous]

Hi All,

I have a requirement to display the Project Name and Client Name  as per the selected project in the slicer.

Example: in the page i have only one project name slicer  and two card,one for the project name and one for  the clinet name .So  when ever the person slected project name in the slicer  the slected project name needs to be disply in the project name card and with respected client name for the project needs to be displyed in the Client Name Card

for the project name displying i am using the below dax

SELECTEDVALUE('Table'[Project Name])

and for the client name i dont have any slicer in the page but those two columns are dependent (coming from the same table)

when the project is not selected in the slicer in the cards it needs to  be display All the project in the project name card and all the clients in the client name card

Can some one please help me on this 

Thanks

Nagaraju.g

[amitchandak]

@Anonymous , Not very clear.

Try like

max('Table'[Client Name])
or
concatenatex(Table,'Table'[Client Name])

[manikumar34]

@Anonymous ,

Check with the below DAX.

SWITCH(TRUE(),SELECTEDVALUE('Table'[Project Name]),Distinct('Table'[Client Name]),"No value selected Slicer ")

On card we can pass only single value. So whenver nothing is slected on slicre you can show "No value selected Slicer "

If you find this is helpful Please Accept as a Solution and leave a like.

Regards, 

Manikumar

[Anonymous]

Hi Mani kumar,

Thanks for the quick replay

but the given dax is not giving the results,it showing the below error.

Thanks!!

Nagaraju

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

Please try the following measure:

project name meaure =
IF (
    ISFILTERED ( 'Table'[Project Name] ),
    SELECTEDVALUE ( 'Table'[Project Name] ),
    "All the project"
)

Client name meaure =
IF (
    ISFILTERED ( 'Table'[Project Name] ),
    CALCULATE (
        MAX ( 'Table'[Project Name] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Project Name] = SELECTEDVALUE ( 'Table'[Project Name] )
        )
    ),
    "All the client"
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai