cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Peter_Jeyaraj_I
Helper I
Helper I

Ignore the filter not working

Hi, 

This looks simple and but i tried differently and nothing works for me. Here below i explained the scenario by using sample data

My input data table structure 

QuarterIn/Out FlagID

2010-1IN1
2010-2IN2
2010-3IN3
2010-4IN4
2011-1IN5
2011-2IN6
2011-3IN7
2011-4IN8
2012-1IN9
2012-2IN10
2012-3IN11
2012-4IN12
2010-2OUT13
2010-3OUT14
2011-1OUT15
2011-2OUT16
2011-3OUT17
2011-4OUT18
2012-1OUT19
2012-2OUT20
2012-3OUT21
2012-4OUT22

 

Expected output would be like quarter wise distinct ID count even if i apply a filter on the [In/out flag] column.

I am getting below output when i apply a filter [In/out flag] = "Out" ( See it's missing some quarters 2010-1 & 2010-4)

In/Out FlagOUT
  
QtrCount of Dist ID
2010-22
2010-32
2011-12
2011-22
2011-32
2011-42
2012-12
2012-22
2012-32
2012-42

but i need the below output

QtrCount of Dist ID
2010-11
2010-22
2010-32
2010-41
2011-12
2011-22
2011-32
2011-42
2012-12
2012-22
2012-32
2012-42

Now i used ALL function 
Distinct ID = CALCULATE(DISTINCTCOUNT([ID]),
ALL(
Table[In/Out Flag]
))...  but still missing some quarter figures. 

 

Regards, 

Peter I

1 ACCEPTED SOLUTION
v-lid-msft
Community Support
Community Support

Hi @Peter_Jeyaraj_I ,

 

It is caused by when you filter the "OUT", the first field quater are also filtered. We can create a spreate calculated table to meet your requirement:

 

QuarterTable = DISTINCT('Table'[Quarter])

 

3.PNG4.PNG5.PNG

 


BTW, pbix as attached.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-lid-msft
Community Support
Community Support

Hi @Peter_Jeyaraj_I ,

 

It is caused by when you filter the "OUT", the first field quater are also filtered. We can create a spreate calculated table to meet your requirement:

 

QuarterTable = DISTINCT('Table'[Quarter])

 

3.PNG4.PNG5.PNG

 


BTW, pbix as attached.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hi @v-lid-msft ,

I tried the same las time but didn't work for some reason. Now, it's working fine. 

 

Thanks & Regards, 

Peter I

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors