Forum Discussion
Filtering by an unfiltered column
R_S add this measure
Region Avg = VAR __region = SELECTEDVALUE ( 'Table'[Region] ) RETURN CALCULATE ( AVERAGE ( 'Table'[Amount] ), ALL ( 'Table'[Company] ), 'Table'[Region] = __region )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
R_S add this measure
Region Avg =
VAR __region = SELECTEDVALUE ( 'Table'[Region] )
RETURN
CALCULATE (
AVERAGE ( 'Table'[Amount] ),
ALL ( 'Table'[Company] ),
'Table'[Region] = __region
)
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
This is great, could I take it a step further and do something like the code below (it doesn't quite work) and return a table of results?
NewTable = VAR __region = SELECTEDVALUE(BaseInfo[Region]) RETURN SELECTCOLUMNS(FILTER(BaseInfo, BaseInfo[Region] = SELECTEDVALUE(BaseInfo[Region])), "Company", BaseInfo[Company], "Segment", BaseInfo[Segment], "Region", BaseInfo[Region])
