Bar Chart - Filter out Empty Dimensional values

[jpjust]

Hi,

I have an table like below.

Appname                                                     Tag                                   sum(Sessioncount)

App-A                                                          Tag1                                   29,903

App-A                                                           -                                            1000

If I convert this to bar chart, the session count on the y-axis becomes 30,903. I want to ignore the empty tag so my results will be 29,903.

How can I achieve the end result? Any set analysis can be applied on the measure to filter out tag that has null values?

Dimension : App Name

Measures (Length of bars) : Num(Sum([Session Count]),'#,##0')

Thanks very much

[abhijitnalekar]

Hi @jpjust ,

Please use below expression

sum({<Tag-={''}>}Sessioncount)

[jpjust]

Thanks Abhijt, that works.

I have an another situation here (some how my dataset isn't that clean so have to deal with it)

Appname                                   AppStream                  Tag                                   sum(Sessioncount)

App-A                                            StreamA                         TagG                              29,903

App-A                                            Stream A                                   -                              1000

App-B                                            Stream B                     TagABC                             2000

App-B                                                       -                                -                                       1000

APP-C                                           Stream C                       -                                        3000

I want to include first record for App-A, first record for App-B and the App-C.

I tried many possible combinations of IF statements such as below but did not work as expected.

IF(NOT ISNULL([App Stream]) and NOT ISNULL(TagCUST),sum({<TagCUST-={''}> }[Session Count]), [Session Count])

IF(NOT ISNULL([App Stream]) OR ISNULL(TagCUST), sum({<TagCUST-={''}> }[Session Count]), [Session Count])

IF(NOT ISNULL([App Stream]) and ISNULL(TagCUST), sum([Session Count]), [Session Count])

Any help will be appreciated.

Thanks