Forum Discussion

Funkmiester's avatar
Funkmiester
Advocate I
8 years ago
Solved

cross filtering columns in the same table

This is so basic apologies, I'm missing something. I have a fact table containing organisations, they are grouped in a separate groups, there are mutliple entries for each  organisation in the tab...
Need Help
  • Stachu's avatar
    Stachu
    8 years ago

    you will need second table for this - otherwise filter you put on Org Name will overwrite one coming from the Org Group, tables shouldn't have joins
    new table (named Slicer) 

    Org NameOrg Group
    Org11
    Org21
    Org32
    Org42
    Org53
    Org63
    Org74
    Org84
    Measure = 
CALCULATE(
SUM('Table1'[Score]),
INTERSECT(ALL('Table1'[Org Group]),VALUES(Slicer[Org Group]))
)

     

Stachu's avatar
Stachu
Community Champion
8 years ago

the 'Org Name' in the chart should come from the Table, not the Slicer, that should give the proper sum - is this the case?
so - for filtering you use Slicer[Org Name], in the visual you use Table[Org Name]

EDIT - spelling

Funkmiester's avatar
Funkmiester
Advocate I
8 years ago

It was a PICNIC error (problem in chair, not computer)

 

Your solution worked perfectly but I had a filter on the bar graph visual from before that meant it didn't display properly. Many, thanks,