How to filter few of many values in line graph

[rajend12]

Hey,

I need to filter Blank closed date column and find the average and max of "Case age in days" column:

Also, I have other values to plot in line graph as below:

Please suggest some ways to use filter for the bottom two values used.

Thanks.

[v-eqin-msft]

Hi @rajend12 ,

Sorry to disturb you...

But did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @rajend12 ,

Here is my pbix file.

1.Calculate the average and max when the closed date is blank:

2.Calculate the average and max when the closed date is not blank:

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

Best Regards,

Eyelyn Qin

[amitchandak · Accepted solution]

@rajend12 , you can use a slicer on the bank close date. Or join both open and close date to date table and one active, one inactive relation. And use userelation to choose date.

refer:https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

or you can use in filter

example

calculate( [measure], filter(Table, Table[Closed Date] <date(2020,02,02)))