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.
I have a table that contains ~2900 rows with columns. You can see it in the screenshot below.
I am trying to count the orders (each order has a row in this table) and create visualizations based on the figures.
The problem is that the formulas return strange values:
Measure = countrows('Orders') returns 50
Measure = count('Orders'['Count']) returns 50 (after creating the column Count=1)
Measure = calculate(countrows('Initial Orders'),all('initial orders')) returns the right number, but then if I add Axis (categories of products) I get the same figure for each value.
Please help me figure this out.
Thanks.
Solved! Go to Solution.
Hi.
I solved the problem.
I guess it was some kind of bug.
All I did was to copy the source data (the whole table as it is), from a multiple sheet xlsx to a csv file and then use that file as source. And now everything works fine, COUNT, COUNTA and COUNTROWS.
Thanks for your interest!
I faced the same issue.
I have country names in a column and I need to count the number of times they appear.
I used the following DAX to count the number of times they appear in the table -:
Hi @adriansuteu,
Can you share the sample file to test? I can't find the columns which you used in the formula.
In addition, can you provide some detail content of your opertions? It will be help for troubleshooting.
Regards,
Xiaoxin Sheng
Hi.
I solved the problem.
I guess it was some kind of bug.
All I did was to copy the source data (the whole table as it is), from a multiple sheet xlsx to a csv file and then use that file as source. And now everything works fine, COUNT, COUNTA and COUNTROWS.
Thanks for your interest!
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |