Count values from different columns

[madferit]

Hi, im learning the basic and im stucked in a very simple dax. Maybe you can give me a hint on a table that im workingn on it.

I need count how many time a value from a column match a value from a different one. I need make another table coz i dont own the original table. I have done a matrix to show the visual and but now i have to work with a new table to summarize anothers value and make a target KPI

Here's the table. I need count how many time every client order a single Item

Im trying to make something like this.

 

Regards

[v-lili6-msft]

HI, @madferit

You could use COUNTA Function to create a measure as below:

Q Item = CALCULATE(COUNTA(Table1[Date]) )

and use Drill mode in a matrix visualization as below:

Best Regards,

Lin

[madferit]

Hello, thanks for the answer. I tried this but the result it count me the total of rows with a single date, it give 9 for every single result.

Regards

[v-lili6-msft]

hi, @madferit

here is my pbix file, please try it.

https://www.dropbox.com/s/4mcrvvzcfps16ah/Count%20values%20from%20different%20columns.pbix?dl=0

if not your case, Please share your sample pbix and expected output for us. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

Best Regards,

Lin