Forum Discussion

ravichandra0788's avatar
ravichandra0788
Frequent Visitor
8 years ago
Solved

Regarding multiple values display in KPI

Hi ,   I have a dataset like below    DEPTNO DNAME LOC 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON   Now in powerBI i am using 'c...
Need Help
  • Stachu's avatar
    Stachu
    8 years ago

    I wrote from memory, expression is missing

    DepartmentNames =
IF (
    ISFILTERED ( dept[DNAME] ),
    "selected departments are "
        & CONCATENATEX ( VALUES ( dept[DNAME] ), dept[DNAME], ", " ),
    "No department selected"
)
ravichandra0788's avatar
ravichandra0788
Frequent Visitor
8 years ago

Hi Stachu,

 

Thanks for the quick response,However suggested solution is not working.

 

Regards

Ravichandra JL

 

Stachu's avatar
Stachu
Community Champion
8 years ago

I wrote from memory, expression is missing

DepartmentNames =
IF (
    ISFILTERED ( dept[DNAME] ),
    "selected departments are "
        & CONCATENATEX ( VALUES ( dept[DNAME] ), dept[DNAME], ", " ),
    "No department selected"
)
  • ravichandra0788's avatar
    ravichandra0788
    Frequent Visitor
    8 years ago
    Thanks Stach :)