DAX to group if it match all 4 criteria

[AAAbbbnewbie]

Dear Experts, need your help on this. I will need to create a visual to show the number of multiple claims created with the same type of criteria. Should the data matches with all 4 criteria as below, i will be considered as 1. 

example: 2904805982 (all 4 criteria matched hence it will considered as 1 duplicated) 

Shipment Id	Request Created By Team	Standard Note	Request / Activity Type
2904805982	CS BL-Backline	totalLoss.note	req.type.claimLiabilityLoss
2904805982	CS BL-Backline	totalLoss.note	req.type.claimLiabilityLoss
7986019495	CS BL-Sales Support	totalLoss.note	req.type.claimLiabilityLoss
1931347294	KAD-Key Accounts Desk	totalDamage.note	req.type.claimInsuredDamage
8579837722	CS BL-Backline	missingPiece.note	req.type.claimLiabilityLoss
7032983145	KAD-Key Accounts Desk	other.note	req.type.claimNonShipment
1114751842	KAD-Key Accounts Desk	other.note	req.type.claimNonShipment

[Anonymous · Accepted solution]

Hi @AAAbbbnewbie ,

Not sure. if you want a table, try:

Table 2 = DISTINCT('Table')

Or a measure:

Measure = COUNTROWS(DISTINCT('Table'))

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum