Forum Discussion

VandanaPulluri's avatar
VandanaPulluri
Frequent Visitor
7 years ago
Solved

Dynamic display value

Hi,   I have got 4 different datasets with calcualted Mann Kendall P values : 1)  Main Dataset holds complete data 2) P value by Country (R script) 3) P value by Region (R script) 4) P value By...
Need Help
Tips and Tricks
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    Hi VandanaPulluri ,

    Please add blank between VAR and _Selectedvalue in the first line, the Var is a key work, it should be var _SelectedValue rather than VAR_SelectedValue.

    Best Regards,

    Teige

parry2k's avatar
parry2k
Super User
7 years ago

VandanaPulluri you can create a measure with Switch function 

 

Show Measure = 
VAR __selectedValue = SELECTEDVALUE( CountryTable[CountryTableColumn] )
RETURN
SWITCH( TRUE(),
__selectedValue = "Country", [Country Measure],
__selectedValue = "Region", [Region Measure],
[Product Measure]
)
VandanaPulluri's avatar
VandanaPulluri
Frequent Visitor
7 years ago

Tried with the below but syntax error.

 

Measure= VAR__SelectedValue= SELECTEDVALUE(PMS_COMPLAINT_COUNTRY[COUNTRY_ORIGIN_NM])
RETURN
SWITCH(TRUE(),
__SELECTEDVALUE= "COUNTRY_ORIGIN_NM",PMS_COMPLAINT_COUNTRY[MannKendallY],
__SELECTEDVALUE= "PMS_COMPLAINT_COUNTRY",PMS_COMPLAINT_REGION[MannKendallY], [MannKendallY])
 
any further suggesstion please...
    • VandanaPulluri's avatar
      VandanaPulluri
      Frequent Visitor
      7 years ago

      Please see the below

      • TeigeGao's avatar
        TeigeGao
        Solution Sage
        7 years ago

        Hi VandanaPulluri ,

        Please add blank between VAR and _Selectedvalue in the first line, the Var is a key work, it should be var _SelectedValue rather than VAR_SelectedValue.

        Best Regards,

        Teige