Formula error

[Anonymous]

Hi Experts

having trouble with the following formula.

Criteria....

ProfitabilityMeasures[MeasurName] is Net Sales or Gross Margin

so if Net Sales is selected  and reported is select then

[NSvPY2% (Reported AOP)]

 which is fine...

The trouble i and having is if neither NOE or Reported is selected then i want the formula to return...

InorganicMeasure2= "Organic", [% Organic Growth]

 or else blank is nothing at all is selected...

% Reported Central = 
VAR ProfitbabilityMeasure2 = SELECTEDVALUE(ProfitabilityMeasures[MeasureName])
VAR ReportingMeasure2 = SELECTEDVALUE(Reporting[Reporting])
VAR InorganicMeasure2 = SELECTEDVALUE(InOrganic[InOrganic])

RETURN 

SWITCH(TRUE(),          
AND(
    ProfitbabilityMeasure2 = "Net Sales",
    ReportingMeasure2 = "Reported"), [NSvPY2% (Reported AOP)],
            AND(
    ProfitbabilityMeasure2 = "Net Sales",
    ReportingMeasure2 = "NOE"),[NSvPY4% (NOE @ AOP Rate)],
               
     InorganicMeasure2= "Organic", [% Organic Growth],   
BLANK(),0)

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

How about adding the conditions explicitly like below?

and(ReportingMeasure2 <> "Reported", ReportingMeasure2 <> "NOE"), [InorganicMeasure2]

Best Regards,
Dale

[Anonymous]

thanks dale....sorted...

[Greg_Deckler]

Can you post sample data in text? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Hi Greg

I understand how question should be answer and it always help to provide sample data...on this occurance it virtually impossible to do so......really sorry