Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
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/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
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