Forum Discussion
PowerBI, if value exist then replicate
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_ManualUpdatepl. 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.
GoRo2010 i guess DuplicateRegistered value will appear only when there are multiple values for same cust_No, in that case you can have simple calc column like below
negi007 , here is an example of what I am trying to replicate, because CustNo 1400083 has the value of "DuplicateRegistered" all values in ManualUpdate needs to be true, as per example, CustNo 999999 does not have that value in DuplicatesCheckAmended thus all CustNo 999999 needs to be false, I hope this explains it better.
Thank You
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_ManualUpdatepl. 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.