DAX to group if it match all 4 criteria

AAAbbbnewbie — Mon, 05 Jun 2023 10:09:16 GMT

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

Re: DAX to group if it match all 4 criteria

Anonymous — Wed, 07 Jun 2023 02:57:39 GMT

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

topic DAX to group if it match all 4 criteria in DAX Commands and Tips

DAX to group if it match all 4 criteria

Re: DAX to group if it match all 4 criteria