topic Bar Chart - Filter out Empty Dimensional values in App Development

Bar Chart - Filter out Empty Dimensional values

jpjust — Wed, 02 Mar 2022 17:17:16 GMT

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 — Thu, 03 Mar 2022 09:36:58 GMT

Please use below expression

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

jpjust — Thu, 03 Mar 2022 17:14:29 GMT

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