Forum Discussion

Wangfl's avatar
Wangfl
Frequent Visitor
4 years ago
Solved

Switch + Selectedvalue return blank

Hello everyone, I'm struggling to solve a problem with a measure.   I am using Switch + Selectedvalue to build a customized P&L report in Power BI, but two of lines "Other COGS" and "Ratio 1 retur...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    If you are performing a division, you are going to need to remove the row filters. Something along the lines of:

     

     

    Ratio =
VAR _Profit =
    CALCULATE ( [Gross Profit], ALL ( 'P&L Structure' ))
VAR _NetSales =
    CALCULATE ( [Net Sales], ALL ( 'P&L Structure' ))
RETURN
    DIVIDE ( _Profit, _NetSales )

     

     

Wangfl's avatar
Wangfl
Frequent Visitor
4 years ago

Hi Thank you for fast response.

 

however, it seems like the column quality is all good..

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

Just for future reference, I actually meant (though my wording was indeed confusing) that one of the actual values may contain a blank at the end of the word/string - not a blank as an actual value. If you perform a Trim on the column, it cleans up any blank (character) at the end of a string