How to enable Conditional show of measures based on selection in other unrelated field in data model ?

[shekhar_analyti]

Hi All ,

How to enable Conditional show of measures based on selection in other unrelated field in data model ?

NOTE : It should be done without use of Variable Over view and Action/Triggers . However LET can be used in load script .

Here in my requirement ...

Line chart is showing Sales , Loss  and Expense trend , month wise .

I have a field called Measure with field values as Sales , Loss , Expense .

a) when user has not selected any thing in Measure Field then chart should display all data as is .

b) When user selects Loss from Measure then chart should show only Loss trend , similarly if two vales are selected in Measure field then those two should be shown in chart ...

Thanks & Regards

Shekar

[shekhar_analyti]

PFA ..

[tresesco]

PFA

=Index(Concat(Measure),'Sales')

[Anil_Babu_Samineni]

Simple and so neat

[shekhar_analyti]

Hi Tresesco ,

   Thanks for reply . I wanted this to be achieved in expression , without using conditional checkbox .

    Is this possible ?

[tresesco · Accepted solution]

This?

If(Index(Concat(Measure),'Sales'), sum(Sales))