Creating a new calcuated column based on grouping of exisitng column

[Anonymous]

Hi Team,

I have 3 columns Id, Location, date , please check below table : -

Id	Location	Date	New Calculated Column
1	New York	5 March	New York
1	New York	6 March	New York
2	New York	5 March	Multiple States
2	California	6 March	Multiple States

I want to acheive this result of New calculted column, could you please help me with this ?

Thanks,

Shubham 

[az38]

Hi @Anonymous 

try a measure

Measure = 
IF(
 CALCULATE(DISTINCTCOUNT(Table[Location]), ALLEXCEPT(Table, Table[Id]) ) = 1,
 MAX(Table[Location]),
 "Multiple States"
)

[Anonymous]

Thanks it is working as measure but i wanted a calculated column as i wanted to use it in Donut chart.

[az38]

@Anonymous 

do almost the same

Column = 
IF(
 CALCULATE(DISTINCTCOUNT(Table[Location]), ALLEXCEPT(Table, Table[Id]) ) = 1,
 Table[Location],
 "Multiple States"
)