Forum Discussion

mclawler's avatar
mclawler
Icon for Helper III rankHelper III
2 years ago
Solved

How to exclude duplicate values

Hi there, I am trying to remove duplicate transactions and keep a certain type.   I need the Customer Count to equal 22 and the Amount Sum to equal $110,500   The logic should be: If the same "Cu...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Why should the answer be 110,500?  Share data in a format that can be pasted in an MS Excel file.

mclawler's avatar
mclawler
Icon for Helper III rankHelper III
2 years ago

H! I have created 2 measures that get me the correct grand totals, but the row items are still incorrect.

 

 

The Existing PCL Increase is correct = 5 units for $10,000

The New PCL is incorrect, should = 17 units for $102,500

 

I have created a pbix for testing here : PCL Testing.pbix

 

If the SAME Member Number appears for both Existing and New, I need the measure to strip out the data rows pertaining to the New PCL redundant Member Number.  This visual might make it clearer.  Include all black and green(duplicate member number), exclude the red:


Member NumberProductAmount BookedFundedDatePCL Increase/PCL New
1110410PERSONAL CREDIT LINE$9,500.0029-Jul-24New PCL
1239460PERSONAL CREDIT LINE$10,000.0022-Jul-24New PCL
1472450Personal Line$5,000.0010-Jul-24Existing PCL Increase
1596150PERSONAL CREDIT LINE$14,000.0011-Jul-24New PCL
2316130PERSONAL CREDIT LINE$7,000.0011-Jul-24New PCL
2588730Personal Line$1,500.006-Jul-24Existing PCL Increase
2588730PERSONAL CREDIT LINE$1,500.006-Jul-24New PCL
3215470PERSONAL CREDIT LINE$4,500.0031-Jul-24New PCL
3574660PERSONAL CREDIT LINE$5,000.0024-Jul-24New PCL
3697240PERSONAL CREDIT LINE$4,000.0030-Jul-24New PCL
4338890PERSONAL CREDIT LINE$5,000.001-Jul-24New PCL
4562300PERSONAL CREDIT LINE$5,000.0024-Jul-24New PCL
5563620Personal Line$500.0030-Jul-24Existing PCL Increase
5563620PERSONAL CREDIT LINE$500.0030-Jul-24New PCL
5648730PERSONAL CREDIT LINE$10,000.0023-Jul-24New PCL
6546300PERSONAL CREDIT LINE$1,000.0018-Jul-24New PCL
7412220PERSONAL CREDIT LINE$10,000.0029-Jul-24New PCL
7536160PERSONAL CREDIT LINE$2,500.002-Jul-24New PCL
7898990PERSONAL CREDIT LINE$2,000.0024-Jul-24New PCL
8523290Personal Line$1,000.0017-Jul-24Existing PCL Increase
8979840PERSONAL CREDIT LINE$500.0030-Jul-24New PCL
9514250Personal Line$2,000.0010-Jul-24Existing PCL Increase
9632420PERSONAL CREDIT LINE$10,000.0031-Jul-24New PCL
9873000PERSONAL CREDIT LINE$500.0024-Jul-24New PCL