Not reflecting

[soniasweety]

hi all,

I have a chart when I select  filter it is not reflecting

used dimension: =aggr(if(JNum>=$(vMTrend),MonthName([JDate])),[JDate])

measure1: count({<[FStatus]={'Joined'},[In/Ex]={"In"}>}[ID])

meausre2: count({<[FStatus]={'Joined'},[In/Ex]={"ex"}>}[ID])

selected  In/Ex  filter  the chart is not reflecting

[sunny_talwar · Accepted solution]

Try this

measure1: count({<[FStatus]={'Joined'},[In/Ex] *={"In"}>}[ID])

meausre2: count({<[FStatus]={'Joined'},[In/Ex] *={"ex"}>}[ID])

[Anil_Babu_Samineni]

In case, If you want to know the filter based ID's then why you are using Set analysis for [In/Ex] ??

[soniasweety]

not working giving 0 s

[soniasweety]

chart is showing in and ex data in two lines

and if I use that also  filter means it should work na

[sunny_talwar]

So, your original expressions worked, but by adding an asterisk the expression become 0? Really or are you kidding me

[soniasweety]

sorry its working

but when I select in  Ex values showing 0

I saw that

[sunny_talwar]

So, that's the good thing right? You wanted your expression to react to In/Ex field selections, right? Now it is doing that... what is the issue?

[soniasweety]

is there any way to hide the other line?

[sunny_talwar]

What other line?