Forum Discussion

Cscullio's avatar
Cscullio
Frequent Visitor
9 years ago

AllSelected In A Summarize Table

I have a table of Months, Salesperson and Sales. I want to create a summary table of the median sales total for each month. I am using the following formula   FilteredValues = Summarize(AllSelect...
Need Help
Cscullio's avatar
Cscullio
Frequent Visitor
9 years ago

Hi Tom,

Thanks but that is not quite what I am trying to achieve.

I need a table which has one row per month and gives the mendian for each month based on the selections, so I am trying to do this as a Summarize table.  Is there a way to create a summarize table that updates according to selections?   Using AllSelected doesn't seem to have any effect.

 

TomMartens's avatar
TomMartens
Super User
9 years ago

Hey,

 

you can achieve what you want by using Month the Measure in a table vis

 

The second table shows all the data.

 

You can't use a calculated table / virtual table, as a source for a visual, due to the fact that it is static (reflecting the moment (current selections) when you calculate the table.

 

For this reason, you have to use a measure, unfortunately, but currently I can't see why a measure is not "good enough"