include all and at the same time include null values also.. Count({<SalesMan={"*"}>} Distinct PNam )

[RheaQv12]

Hi there,

I have a scenario where there are nulls as part of join in the data model so i am not able to replace the nulls at the load script level... I have this scenario where the user will select the SalesMan listbox and this selection should not be applied to one of the straight table so SalesMan={*} and counting the ProductName values... * is excluding the NULL values

but there are certain ProductNames which do not have a SalesMan...so how do i get both i.e SalesMan={"*"} - this is required because i do not want to SalesMan dimension to change when the user selects the SalesMan in the listbox (the stragiht table should not change) ---not sure how to put this...

Count({<SalesMan]={null}  and     SalesMan]={"*"}>} Distinct PName)  - something like this

thanks a lot

[Arthur_Fong · Accepted solution]

Try: 

Count({<SalesMan=>} Distinct PName)

[RheaQv12]

Hi

thanks but this will change the data in the straight table when i select the SalesMan value in a listbox - i do not want the st table to change when a value is selected in salesman listbox

the st table with salesman as dim should not chabge thats why i was using *

[sunny_talwar]

This expression by @Arthur_Fong is doing exactly that... ignoring selection in SalesMan field while allowing you to see nulls

Count({<SalesMan=>} DISTINCT PName)

You can also write this without the = sign 

Count({<SalesMan>} DISTINCT PName)

[RheaQv12]

Thank you @Arthur_Fong and Sunny_Talwar