Forum Discussion
Resolver IIterate through a measure
PowerBITestingG I would think:
Wanted measure = VAR __Table = SUMMARIZE(ALLSELECTED('Table'),[Country],[Condition],"Quantity",[Quantity]) RETURN SUMX(FILTER(__Table,[Condition] = 1),[Quantity])
Community ChampionPowerBITestingG I would think:
Wanted measure =
VAR __Table = SUMMARIZE(ALLSELECTED('Table'),[Country],[Condition],"Quantity",[Quantity])
RETURN
SUMX(FILTER(__Table,[Condition] = 1),[Quantity])
PowerBITestingGGreg_Deckler Can you see any future issues from using allselected inside a sumx? or we are not using it directly in it, so its not a problem?
Thank you!
- Greg_Deckler
PowerBITestingG ALLSELECTED just removes the direct filters within the visual, so in this case Country and Condition, for example. It preserves all of the other filters coming from visual selections in other visuals. You can use ALLSELECTED on it's own, wrapped in a FILTER or SUMMARIZE or any other function that expects a table of values as a parameter. No, it is not resticted for sole use in CALCULATE but a lot of people seem to believe that is the case.
- PowerBITestingG
"For the sake of simplicity, we shorten that complex article into this best practice: never use ALLSELECTED inside an iteration."
AVERAGEX (ALL ( 'Product'[Brand] ),CALCULATE ([Margin %],ALLSELECTED ()))It is not that ALLSELECTED would not work in this code snippet. The problem is that ALLSELECTED semantics are very complex, nearly beyond human comprehension. Therefore, you might obtain crazy numbers that are extremely complex to explain and most likely not the ones you were needing.