Forum Discussion
Need urgent: Same customer ID With different First and Last Names Should be display in table visual
- Anonymous2 years ago
Thanks for the reply from danextian , please allow me to provide another insight:
Hi mg00842082 ,Here are the steps you can follow:
1. Add Column – Index Column – From 1.
2. Create measure.
Count = CALCULATE(COUNT('Table'[Customer ID]),ALLEXCEPT('Table','Table'[Customer ID],'Table'[First Name],'Table'[Last Name],'Table'[Address 1],'Table'[Address 2],'Table'[Address 3]))Flag = var _minindex=MAXX(FILTER(ALL('Table'),[Customer ID]=MAX('Table'[Customer ID])&&[Count]>1),[Index]) return IF( [Count]=1||MAX('Table'[Index])=_minindex,1,0)3. Place [Flag]in Filters, set is=1, apply filter.
4. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thanks for the reply from danextian , please allow me to provide another insight:
Hi mg00842082 ,
Here are the steps you can follow:
1. Add Column – Index Column – From 1.
2. Create measure.
Count =
CALCULATE(COUNT('Table'[Customer ID]),ALLEXCEPT('Table','Table'[Customer ID],'Table'[First Name],'Table'[Last Name],'Table'[Address 1],'Table'[Address 2],'Table'[Address 3]))Flag =
var _minindex=MAXX(FILTER(ALL('Table'),[Customer ID]=MAX('Table'[Customer ID])&&[Count]>1),[Index])
return
IF(
[Count]=1||MAX('Table'[Index])=_minindex,1,0)
3. Place [Flag]in Filters, set is=1, apply filter.
4. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly