The function is working properly
The issues you face are 2 fold -
first the IF statement will process each record ("row") individually - as soon as it gets a "True" condition it will execute the Then clause and will move on to the next reccord
so conceptually what are trying to do will not work -
Suggest you look at splitting the single dimension "Coverage Level Copy" into individual dimension and re- think how to get the count you need
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Hi Jim, thanks for your response.
I also thought about splitting the Coverage Level Copy into multiple other dimensions (as long as there are no multiple items in one cell), but this won't be helpful visualizing it. My end goal is not just counting numbers but essentially visualizing all the items in one view (like Calculation 1 image I attached). Creating multiple syntax for each item won't be helpful either for the same reason.
It'd be ideal if I can make the syntax above examine all records every time a new line starts (if and elseifs until it ends).
Well Good Luck
1 of 1 people found this helpful
What about if you split it into separate calculations?
IF CONTAINS([Coverage Level Copy], 'Sub-national')
IF CONTAINS([Coverage Level Copy], 'Global')
Now you have parsed the values into individual columns. You can place Measure Names on Rows and Measure Values on Columns, filtering Measure Names to only the values you want to appear in the view. You can use a text table/bar chart (or could even put a more granular field on Detail to create a distribution plot).
This works! Thanks Ben!!