COUNTROWS formula !
In case, I have a table containing the customer name and customer key, product name, product key, order number, country name and country key, and I used the COUNTROWS formula and added the name of the table. What will happen in the measure and on what basis did this result come out please!
It will count all the table rows regardless of the number of columns. If you add a filter like customer name then it will group the number of rows based on customer name
Thank you for the clarification, if you allow me, when you added this dax and put it in the card Visula, no filter was added, yet the number of products that were sold appeared, why did the number of customers, for example, or the number of countries not appear, this is the essence of the question, Explain please!
Because you need a group by function, in DAX the group by is the filter you add, whether it is country, product color, etc. The amount on its own is counting the total number of rows when you add different columns from the same table, the amount will change and distribute accordingly.
More explanation, accompanied by an example please!
Submit an answer
