Forum Discussion

sheap069's avatar
sheap069
Helper III
5 years ago
Solved

Get Values and Counts in Table

Hello,   I have a data set with Applications and Groups, and the data is related by the Group ID with the respective Application IDs. Application IDs have cities.    Application City 1 Delhi...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi sheap069 

     

    You want a Table visual to display it? So it is a measure

     

    Result = 
VAR T1 = GROUPBY(CityTable,CityTable[City],"COUNT",COUNTX(CURRENTGROUP(),[City]))
VAR T2 = ADDCOLUMNS(T1,"TEST",[City]&" ("&[COUNT]&")")
RETURN
CONCATENATEX(T2,[TEST],", ")

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi sheap069 

 

You want a Table visual to display it? So it is a measure

 

Result = 
VAR T1 = GROUPBY(CityTable,CityTable[City],"COUNT",COUNTX(CURRENTGROUP(),[City]))
VAR T2 = ADDCOLUMNS(T1,"TEST",[City]&" ("&[COUNT]&")")
RETURN
CONCATENATEX(T2,[TEST],", ")

 

sheap069's avatar
sheap069
Helper III
5 years ago

Perfect, thank you!!