Forum Discussion

gianmarco's avatar
gianmarco
Icon for Helper IV rankHelper IV
2 years ago
Solved

Wrong formula in calculated column

Dear All, I have the following calculated table:   This works as long as I have at least a value which is not only 0 in "Cashflow[Scenario]". In fact, in this example, I have values 0 and 1...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi gianmarco ,

    Please have a try.

    Max Scenario = MAX(Cashflow[Scenario]) // create measure for max scenario

    Calculated Table = 
FILTER( // filter out blank or zero values
    ADDCOLUMNS( // add new column for scenario
        Cashflow,
        "Scenario", IF(Cashflow[Scenario] = 0, [Max Scenario], Cashflow[Scenario]) // replace 0 with max scenario
    ),
    NOT(ISBLANK(Cashflow[Value])) && Cashflow[Value] <> 0
)

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

You are filtering too soon. Do the summarize first and then check your scenarios.