Forum Discussion

R_S's avatar
R_S
Helper I
6 years ago
Solved

Filtering by an unfiltered column

Hi,   I have a requirement where I will have a tab where people can choose a company via a slicer. That company has a region associated with it (in the same table). The slicer will be synced with a...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    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.⚡

parry2k's avatar
parry2k
Super User
6 years ago

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.⚡