Forum Discussion

GoRo2010's avatar
GoRo2010
New Member
3 years ago
Solved

PowerBI, if value exist then replicate

Good Day,   I am looking for a DAX command, as per example below, I have been able to identify duplicate email addresses ect, what I need assistance with is to say, if CustNo "1400083" as per this ...
Need Help
  • negi007's avatar
    negi007
    3 years ago

    GoRo2010 

     

    you can create below calc column in this case

     

    ManualUpdate =
    var _tempTab = SUMMARIZE(FILTER(Tab_cust,Tab_cust[DuplicatesCheckAmend]="DuplicateRegistered"),Tab_cust[CustNo],"CountDup",COUNTx(Tab_cust,Tab_cust[DuplicatesCheckAmend]))
    var _ManualUpdate = if (CONTAINS(_tempTab,Tab_cust[CustNo],Tab_cust[CustNo]),TRUE(),FALSE())
    return
    _ManualUpdate
     
     

    pl. try this solution. also whenever you are raising any query, it is advisble to share data that can be copied. I had to convert the image to data.

     

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

you can also do this:

ManualUpdate2 = var _t1='Tab_cust'[CustNo]
         var _t2 ='Tab_cust'[DuplicatesCheckAmend]
         var _result = CALCULATE(COUNTROWS(),
         FILTER(ALL('Tab_cust'),
               'Tab_cust'[CustNo]=_t1
               && 'Tab_cust'[DuplicatesCheckAmend]="DuplicateRegistered"))
               RETURN
               if(_result=1,TRUE,FALSE)