Hi,
In a view called sales, I have pickup and delivery orders.
Total orders or rows is for example 100.
if I do a filters of date and only select delivery then total rows is shrinked to like 30.
I want to show the total number of rows on screen and after the filtration. should be 30 not 100.
Note: I have a unique column called order ID.
I’ve tried the following but they give me all rows count which is 100. any hint plz.
COUNT(Orders[_RowNumber])
COUNT(UNIQUE(Orders[Order ID]))
Where do you want to show it? How are you filtering?
Hi @Marc_Dillon
I want to show it on the screen like this. See there are some filters above.
what and where is best way to show the number plz
Please note that the above view is from slice “coordinator” in table orders.
If you set a grouping on that view, and “count” as the group aggregate, it will update with those filters.
@Marc_Dillon oh yes yes you are right. It is an easy solution that I did not think about.
Now is ok, Thanks very much.
