Forum Discussion
Count values from different columns
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
3 Replies
- v-lili6-msftCommunity Support
- madferitRegular Visitor
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-msftCommunity Support
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