Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
105 | |
88 | |
73 | |
66 |
User | Count |
---|---|
122 | |
112 | |
98 | |
79 | |
72 |