How about the attached? The formula used is:
then sum([Banks: Automated tellers (per 100k adults)])
With a "Compute Using" set to "Country Name". Basically, if more than one row is returned, it returns 0 for all rows, and if only one row is returned, it displays the summed measure.
Book3 ML Edit.twbx.zip 284.6 KB
Hi Matthew...Thanks for your inputs! It worked perfectly...
I need some more help with the same issue
On another view I need to display multiple measures, including GRP in a tabular chart. And this chart contains BrandLabel in the rows instead of Country. However the behaviour of GRP field must be the same. i.e.
- If only ONE country is selected in filter, show measure A for the selected Country
- If More than ONE country is selected, display measure A = "NA" or 0
When I add Country field to the details section, the tabular view gets altered. How do I achieve the required result in such a scenario?
I have attached a new workbook with sample data scenario.
Oops! I have added workbook...Please let me know if you are not able to view it
Not in the second scenario...if you wish you compile a sample that would be handy.
Thanks Prashant....but I do not have Country in my tabular chart "Rows" section. Country is a filter on the dashboard in which this view is present, Country is not present in the view itself
Can this be achieved with the above limitation?
One option to achieve the same is with the help of deselect the option of "Show Header" for Country but when multiple countries get selected it will not aggregate the values. For Eg.
If two values repeat for two countries then it will not going to show aggregation of these two.
Country Brand Measure
A x 25
B y 30
B x 45
B y 50
If the above table is your data, after what i did, it looks like:-
Here x is repeating as i Hide only Country label. If in your database brand is not repeating then this method will work perfectly, but if not then table is looks like above view. Is it considerable for you or not?
Unfortunately in my data, Brand is repeating for multiple countries, hence this solution won't be acceptable.
Do let me know if you find another solution to the issue
Yeah pretty close to what i want! However, when multiple countries are selected, column A shows more than one "0"?