Forum Discussion

SHARKBIRD's avatar
SHARKBIRD
Regular Visitor
6 years ago
Solved

Filter from disconnected table

Hi!   I have a fact table with both actual numbers, and budget numbers like the one below.   Date Orign Version Value 1/1-2019 Actual   1.000,00 1/1-2019 Budget A 900,00 1/1-...
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Here is one way.

     

    Selected Budget = calculate(sum(FactTable[Value]), treatas(values(Disconnected[Budget Version]), FactTable[Version]))

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

Here is one way.

 

Selected Budget = calculate(sum(FactTable[Value]), treatas(values(Disconnected[Budget Version]), FactTable[Version]))

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

SHARKBIRD's avatar
SHARKBIRD
Regular Visitor
6 years ago

Hey Pat

 

That's so awesome - it worked exactly as i hoped for! TREATAS is a new favorite for now 🙂