Forum Discussion
count rows with in filter context
HI ,
Need to count the no of rows by including all the filters in dashboard
have a date range start date and end date if i select lets say may 1st to may 31st need to retreive all process with in this range and then count it
i tried calculate (count(process),ALLSELECTED(date) but no luck
can any one help me on this?
2 Replies
Hi Varun511 ,
Does it work just with :
measure = count('yourtable'[process])By default, PBI applies the filters to your measure. So if I understand your requirement correctly, you do not really need to add anything else to your measure.
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/Hello,
Actually have a date table joined with table and granularity is transaction date joined with transaction date so if I do count it will not work for suppose need to get count for may count is 35 but if I do simple count since there are 1400 line items for may month it will show count 1400 instead of 35 hope you got it
