Forum Discussion

AndresSalomon's avatar
AndresSalomon
Helper II
8 years ago
Solved

Measure based on a condition from other table

Hi Community, hoping you can help me with this task.   I have this data table tblForecast:   Category__________Month_____________Cost Cat1________________Sep_______________100 Cat1_____________...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    I believe what you want is something along the lines of:

     

    Measure = CALCULATE(SUM(TblForecast[Cost]),FILTER(RELATEDTABLE(Months),[ForecastOrActuals]="F"))

    Let me know if that works. If not, I'll try to recreate your data and test.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

I believe what you want is something along the lines of:

 

Measure = CALCULATE(SUM(TblForecast[Cost]),FILTER(RELATEDTABLE(Months),[ForecastOrActuals]="F"))

Let me know if that works. If not, I'll try to recreate your data and test.

  • AndresSalomon's avatar
    AndresSalomon
    Helper II
    8 years ago

    Absolutely amazing Greg_Deckler! Worked perfectly. And it will be updated automatically because the column ForecastOrActuals has a DAX formula that put A or F based on other tables conditions. I created a post that is related to this one, maybe you can take a look at it:

     

    https://community.powerbi.com/t5/Desktop/Execute-a-mesure-based-on-a-condition/m-p/345453

    I need to start using RELATED and RELATEDTABLE... Still newbie into this world. 


    Thank you very much! :robothappy:

    Regards,

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      8 years ago

      Hah! My DAX must be getting better! Usually when I try to write a formula from memory instead of recreating the scenario I make some stupid syntax error!! :) I'll take a look at the link.