Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Peter_Jeyaraj_I
Helper II
Helper II

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.

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.