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.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors