Forum Discussion

badger123's avatar
badger123
Resolver I
7 years ago
Solved

Help with measure

Hello,   Hoping someone can help with this. I have tried to simplify my problem with some dummy tables (see pbix file here: https://drive.google.com/file/d/1emMTSkXIrs0D8ZIjVURqC0yLf_70Ma3k/view?us...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

badger123's avatar
badger123
Resolver I
7 years ago

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):

 

DateValues
Jan-191450
Feb-191180
Mar-191300

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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