Forum Discussion
Help with measure
Hi badger123 ,
I don't think you can direct use above formula on your scenario.
You need to change relationship to break auto exist filter, then use current date to filter on correspond team id from other table and use extract id list as filter condition.
Regards,
Xiaoxin Sheng
Hi badger123 ,
AFAIK, power bi slicers not support 'exclude' mode. You can refer to following steps to achieve exclude filter effect.
Steps:
1. Turn off relationship from 'table 3' to 'table 1'.
2. Write a measure to compare between records and summarize related values:
Exclude measure =
VAR _exIDList =
EXCEPT (
CALCULATETABLE ( VALUES ( Table1[Term ID] ), ALLSELECTED ( Table1 ) ),
VALUES ( Table3[Term ID] )
)
RETURN
CALCULATE (
SUM ( Table2[Values] ),
FILTER ( ALLSELECTED ( Table2 ), Table2[Term ID] IN _exIDList ),
VALUES ( Table1[Term] )
)
Notice: if you not turn off relationship, your records will been filtered by auto exist function.
Regards,
Xiaoxin Sheng
Amazing, thanks Anonymous . That works. Do you know how I can sum the values broken down by date fromTable 2? I.e. achieve the following (based on selecting item two in slicer):
| Date | Values |
| Jan-19 | 1450 |
| Feb-19 | 1180 |
| Mar-19 | 1300 |
Hi badger123 ,
I don't think you can direct use above formula on your scenario.
You need to change relationship to break auto exist filter, then use current date to filter on correspond team id from other table and use extract id list as filter condition.
Regards,
Xiaoxin Sheng