Interaction to filer data not working

[murali5431]

Hi All,

I have a chart which shows count of class match "Class Match" = N (bottom right). I have a table to obtain data corresponding to the selection under this chart, as below.

When I select a month, at the bottom right, I am expecting to get, list of parts with  Class Match only "N". But here I am getting Y as well.

The formula used to catpure the count of parts if N amended is as below:

Count of Parts if N Amended = CALCULATE(COUNT('Table'[Class Match]),'Table'['Table'[Class Match]="N")

Please let me know how I could have only parts with Class Match "N" listed.

Thanks,

Murallidhar

[Fowmy]

@murali5431 

Your formula is correct. Please check your data and validate if Y exists for February. Share some data, if possible share your PBIX file to check.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

I accept KUDOS 🙂

YouTube, LinkedIn

[murali5431]

Hello @Fowmy 

My data does have N. As I am not aware how to attach a file, I am pasting some sample data below for Feb 2020. Hope this helps.

Entry No	Valid from	Valid to	PRODUCT_NUMBER	Class Match	Initial Entry Dt
AEFEWFLLK	01-Jan-96	30-Dec-99	67609	Y	24-Feb-20
AEFEWFLLK	01-Jan-96	30-Dec-99	67688	Y	24-Feb-20
AEFEWFLLK	01-Jan-12	30-Dec-99	67698	Y	24-Feb-20
AEFEWFLLK	01-Jan-12	30-Dec-99	67698	Y	24-Feb-20
AEFEWFLLK	01-Jan-96	30-Dec-99	105870	Y	24-Feb-20
AEFEWFLLK	21-Mar-18	30-Dec-99	202864	N	24-Feb-20
AEFEWFLLK	21-Mar-18	30-Dec-99	211895	N	24-Feb-20
AEFEWFLLK	28-Jun-18	30-Dec-99	235012	N	24-Feb-20
AEFEWFLLK	10-Jan-20	30-Dec-99	302535	N	24-Feb-20
AEFEWFLLK	13-Feb-20	30-Dec-99	362776	N	24-Feb-20
AEFEWFLLK	24-Jan-20	30-Dec-99	362826	N	24-Feb-20
AEFEWFLLK	27-Nov-17	30-Dec-99	374967	N	24-Feb-20
AEFEWFLLK	27-Nov-17	30-Dec-99	399295	N	24-Feb-20
AEFEWFLLK	01-Jan-96	30-Dec-99	534823	N	24-Feb-20
AEFEWFLLK	09-Dec-19	30-Dec-99	535547	N	24-Feb-20
AEFEWFLLK	26-Sep-19	30-Dec-99	6G628	N	24-Feb-20
AEFEWFLLK	26-Sep-19	30-Dec-99	6G628	N	24-Feb-20
AEFEWFLLK	11-Dec-19	30-Dec-99	9R261	N	24-Feb-20
AEFEWFLLK	01-Jan-96	30-Dec-99	125554	N	04-Feb-20

Thank you,

Muralidhar

[Fowmy]

@murali5431 

There are 14 rows for N and 5 for Y. It is calculating correctly. You need to check your data. You can save your file in 
One Drive or Google Drive and share the link here.

[murali5431]

@Fowmy 

I am getting the data in the chart correctly. My issue as mentioned initially is :

When I select a month, at the bottom right chart, I am expecting the table on the left to give me only corresponding parts with  Class Match having "N". But here I am getting Y as well in the table as you can see.

Hope this helps to clarify

Thanks,

Muralidhar

[Fowmy · Accepted solution]

@murali5431 

I think it's the visual filter interaction.

Go to Format Tab, Click Edit Interaction, Select the chart and click on the Filter Button of the table visual as you see in the image.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

I accept KUDOS 🙂

YouTube, LinkedIn