Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Help with Calculate arguments

I have a table visual with a measure, and one of the columns in the visual needs to be ignored in caulcating the measure.  I can use the ALL argument, but then it also ignores a slicer I have on the ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

If you look at the last visual, it gives the impression that ID 1 is in both countries.  I want to display the average of all ages in the data, regardless of country, but I also want the report user to be able to see what country they ID belongs to.  I just can't seem to make it work.

 

My second requirement, which adds complexity to all this, is a slicer FOR country.  When Canada is selected, the table visual will ONLY show the average age for Canada, and will ONLY show Canadian IDs. When both countries are selected, it will take the average across both countries and show IDs in both countries.

 

I get that i can use a 2nd visual for the average, but this is just a simplified example to illustrate my problem. I have to have the measure in the table.