Case 295 How to Make Count by Company_Name display as 3 when i select Dim and Expression = Coy Name?

[paulyeo11]

Hi All

I have This Visualization :-

Below Expresion working fine :-

=pick(Match([Pls select 51st Dim],
'E-Mail_List',
'SALES',
'Company_Name'
),
count(DISTINCT $(ColumnDim51)),
sum($(ColumnDim51)
)
)

I have diffcuilty adding one more expression after sum($(ColumnDim51)

I need to Add one more Expression , when user select Expression = Company_Name
and the Table 2 Display Count of 3

May i know how to do moddify the above expression ?

Paul

[edwin · Accepted solution]

if i get your data model correctly, you are missing the value for field COLUMN51 for company name.  this is your script:
WhatIfDimension:
LOAD * INLINE [
Pls select 51st Dim,Column51

SALES,Total_Sales
E-Mail_List,E-Mail_List
Company_Name    <-missing value here - shouldnt there be a value for CompanyName?
];

then to answer your question, you just add a new expression in your picklist:

=pick(Match([Pls select 51st Dim],
'E-Mail_List',
'SALES',
'Company_Name'
),
count(DISTINCT $(ColumnDim51)),
sum($(ColumnDim51)),
sum($(ColumnDim51))  <- add your 3rd exp here
)