Forum Discussion
mg00842082
1 year agoRegular Visitor
Need urgent: Same customer ID With different First and Last Names Should be display in table visual
Hi All. Data in report: Requirement: 1. 10002001 - This Customer ID is available in Row 1 and Row 2 in report. The First Name, Last Name Address 1, Address 2, Address 3 are different t...
- Anonymous1 year 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
mg00842082
1 year agoRegular Visitor
Hi danextian Please find the above table sample data