Forum Discussion

jessicarocha's avatar
jessicarocha
Helper IV
4 years ago
Solved

Display aggregated variable in a graph only if a certain filter selection is met

I have a table that contains forecast values per filial and the sum of the forecast for all filials is considered the group forecast (var forecast 1). Then, I have another variable that contains ano...
Need Help
  • xzmiche's avatar
    xzmiche
    4 years ago

    OK. Understand!

     

    Some updates:

    1. Set relationship between Table 1 vs Table 2:

    2. Create new Forcast 2 measure: 

     

     

    N Forecast 2 = if(ISBLANK(SELECTEDVALUE('Table 1'[Filial])),FIRSTNONBLANK('Table 2'[Forecast 2],1),0)

     

     

    3. Add N Forecast 2 to your graph

     

jessicarocha's avatar
jessicarocha
Helper IV
4 years ago

Thank you very much xzmiche ! That's what I wanted. I really appreciate the help!

xzmiche's avatar
xzmiche
Resolver I
4 years ago

If you don't want to see 0 on graph, we may update measure formula with:

N Forecast 2 = if(ISBLANK(SELECTEDVALUE('Table 1'[Filial])),FIRSTNONBLANK('Table 2'[Forecast 2],1),"")