The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024. 2-for-1 sale on June 20 only!
Register NowFind everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
92 | |
90 | |
72 | |
69 |
User | Count |
---|---|
232 | |
128 | |
117 | |
82 | |
82 |