Forum Discussion

mg00842082's avatar
mg00842082
Regular Visitor
1 year ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    1 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