Forum Discussion
cross filtering columns in the same table
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 Name Org Group Org1 1 Org2 1 Org3 2 Org4 2 Org5 3 Org6 3 Org7 4 Org8 4 Measure = CALCULATE( SUM('Table1'[Score]), INTERSECT(ALL('Table1'[Org Group]),VALUES(Slicer[Org Group])) )
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 Name | Org Group |
| Org1 | 1 |
| Org2 | 1 |
| Org3 | 2 |
| Org4 | 2 |
| Org5 | 3 |
| Org6 | 3 |
| Org7 | 4 |
| Org8 | 4 |
Measure =
CALCULATE(
SUM('Table1'[Score]),
INTERSECT(ALL('Table1'[Org Group]),VALUES(Slicer[Org Group]))
)
Thank you Stachu
I've tried it on the PBIX file I linked to above.
It almost works, it correctly filters the graph so that only the Orgs in the selected group are displayed but they all return the same single value. How can I use the cross filtering but display the individual Score.
I've tried placing almost every attribute in every box. Any ideas?
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 - spellingIt 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,
