Count rows based on two matching columns (static number)

[Anonymous]

Hello,

I am running into a bit of trouble creating a report of returned items. The report I am creating will show me the items returned in the last seven and the number of times they have been back historically. It would show something like the following: 

Part Number | Serial Number | Date of return | Number of times returned

If I filter the data on the reports page I am left with 1 in the number of times returned. To help compensate for this, I've tried to manipulate a column on the data page to count the number of times a part number (Column 1) and serial number (column 2) appear in my data and use that as a reference number that won't be affected by filtering date. 

So far I've tried to create a COUNTROWS function and a MAXX function with no success. I'm still very new to Power BI and DAX. Any help would be greatly appreciated.

Thanks,

Aaron

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[Anonymous]

To clarify, part number and serial number have to match to be a counted value. This is because there are similar serial numbers which have different part numbers and there are similar part numbers with different serial numbers. 

[v-diye-msft]

Hi @Anonymous ,

Please share us your dummy pbix/ simple data and the desired results. that would be easier for us to provide the valuable advice.

[Anonymous]

Samples are in the following links:

Sample PBIX file:

https://drive.google.com/open?id=1_G-8yNJc_aKVdLVZJhxz3vK4zamsbFSi

Sample Excel Source Data:

https://drive.google.com/open?id=16xgiRpaoxd-fC4MOTgKj_9PbKmCzH5OO

[Ashish_Mathur]

Hi,

What exact result do you want?

[Anonymous]

The solution provided above works.

[Anonymous]

Let me know if those files will work, or if you might need additional data for an example.

[v-diye-msft · Accepted solution]

Hi @Anonymous ,

Let me know if you'd like to get the result like this:

Pbix attached; https://wicren-my.sharepoint.com/:u:/g/personal/dinaye_wicren_onmicrosoft_com/ESvDnzL6vNdGm_xn3lkutFIBjRC75oHa6dZxwx-Fc3_dcg?e=OF1W9N