Forum Discussion
Count based on a columns particular value and this count should ignore any available filters
Hi, I need to create a measure, which calcualtes the total count based on a particualr columns value. I know how to do this. However, when I use this meaure, I dont want its value to change if an...
LIn, Thanks for your help here. Your meaure is becoming blank when a value other than "Open" is selecrted from the status slicer. As I mentioned, I want the Status filter to be ignored altogether.
v-lili6-msft
Community Support
Community Supporthi, Anonymous
I retested this formula on my side, it works well.
For example
Basic data
and these three formulas
old Number of Open Requests = COUNTROWS(FILTER('Report requests', 'Report requests'[Status]="Open"))
Number of Open Requests = COUNTROWS(FILTER(ALL('Report requests'), 'Report requests'[Status]="Open"))
my formula
My new Number of Open Requests = COUNTROWS(CALCULATETABLE('Report requests',ALL('Report requests'[Status]), 'Report requests'[Status]="Open"))Then
1. Don't select any value
2. select value form "Status"
3. select value form Status and Year
here is my pbix, please try it.
If it is not your case, please share pbix file or some data sample and expected output . You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin