Forum Discussion

noannish's avatar
noannish
Frequent Visitor
6 years ago
Solved

Calculate stopped filtering - referencing another table

I've been using a slight variation of a measure and today it's not working and I can't figure out why (I hope it's just something silly I'm not seeing).   I have a data list where every single item...
Need Help
  • noannish's avatar
    noannish
    6 years ago

    Thanks - your question triggered me to remember the piece I was missing - just forgot to map the relationship for the new table. My new table has all the unique invoice numbers so that's my 1 and the data source is my many.  Working as intended again.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

noannish 

The structure is not clear to me yet. Are these two tables joined with each other and invoice no is unique in virtual table

Then you could have like this
Virtual Promotion = CALCULATE(SUM(udv_SalesItemsByLine[Values Sales Amt]), Values('Virtual Table'[Invoice Number]))

Virtual Promotion = sumx(summarize('Virtual Table','Virtual Table'[Invoice Number],"_sum",SUM(udv_SalesItemsByLine[Values Sales Amt])),[_sum])

 

Else you need a common dimension. If you are creating a table variable in a measure then there is a different way to deal it