Forum Discussion
Helper IIAssistance with condition logic
Hi All
Have come across a little hurdle for someone of my limited knowledge and require a little assistance in creating a measure that looks at the following condition
I have a table of contents that contains the following
What i would like to acheive is the following,
If client ID contains "activation" then all other rows should equal "True" for that client only
If client ID does not contain " activation then all rows should equal "False" for that client
Would greatly appreciate some assistance
Thanks in advanced
5 Replies
FreemanZSuper User
hi James_Galis1
how are you going to use the measure? Or what context do you have for the expected measure?
- James_Galis1
I hope to represent a visual/ table that will show clients that
a.) have a activation budget
b.) do not have one
I have a distinct client count of 623 in this particular example
I am able to represent the "True" statement from using a text.contains column and it filters out the results as expected
When choosing the "False" argument i wish to represent the clients that dont have the activation budget ( 135, difference between client count and true statement ).
But i am representing the following
Hope i have answered that correctly
Cheers
1. DO NOT change all your rows if a client has no activation - simply create a measure - this keeps your row data for future use.
2. You already have a measure/ way of sorting out active/non-actives - Client Status column.
Simply use that as your filter on whatever visuals you are trying to display.
PadycosmosSolution Sage
You may try using this:
Result = IF(CONTAINSSTRING(SELECTEDVALUE([Budget Budget Name]),"Activation"),"True")
- Ashish_Mathur
Hi,
You should ideally do this with a calculated column formula. If you are OK with that approach, then share data in a format that can be pasted in an MS Excel file.
