Forum Discussion

Tubster66's avatar
Tubster66
Regular Visitor
8 years ago
Solved

Summarize table with filters

Hi   Power BI newbie - apologies if this is rookie error stuff.   I have a SUMMARIZE table generated with Forecast = summarize(budget,Budget[Name],Budget[Period],Budget[Year],"forecast",(calculat...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

     

    Hi Tubster66

     

    Possibly because you are still using the ALL function in your first function.  Possibly try changing that to be ALLSELECTED ??

     Forecast = summarize(
budget,Budget[Name],Budget[Period],Budget[Year],
"forecast",(calculate(sum(Budget[Budget]),ALLSELECTED (Budget[Period]))/12)).

     

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

 

Hi Tubster66

 

Possibly because you are still using the ALL function in your first function.  Possibly try changing that to be ALLSELECTED ??

 Forecast = summarize(
budget,Budget[Name],Budget[Period],Budget[Year],
"forecast",(calculate(sum(Budget[Budget]),ALLSELECTED (Budget[Period]))/12)).

 

  • Tubster66's avatar
    Tubster66
    Regular Visitor
    8 years ago

    Hi Phil_Seamark

     

    Thanks for your reply - it worked.

     

    Much appreciated