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.

     

     

     

Anonymous's avatar
Anonymous
Not applicable
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.