Forum Discussion
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...
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 )
It may be because there is a rogue blank in the field value. Try performing a "Trim" (and maybe "Clean") on the column in Power Query.
or even simpler, instead of referencig the name (value) in SELECTEDVALUE, use the Line Item Number instead
Hi Thank you for fast response.
however, it seems like the column quality is all good..
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
