DAX formula to show calculation within a matrix

[AZ2021]

Hi guys,

I am trying to use this code to show the figure for Gross Profit, EBITDA and Net Profit.

The logic will be using this DAX Code to run through the title coloumn, whenever it sees column matching the description "Gross Profit", "EBITDA", "Net Profit", it will use my measures I created to calculate the relevant figure. 

However it is not showing figures somehow. There must be some error within my DAX formula. Much appreciate if someone can help.

[amitchandak]

@AZ2021 , change selectedvalue with MAX. and check. Also, check are there is any space in the name. or use search in place of =

example 

Switch(true() ,

search("Gross Profilt", max(Mapping[COA level 1]),,0) >0, [Gross profit],

// Add others

)

[AZ2021]

Hi  amitchandak,

Thank you for your response. I replaced my code with your suggestion but an error pop.

[Samarth_18 · Accepted solution]

Hi @AZ2021 ,

Based on solution provided, you need to update your code as below

SelectedYearActual =
VAR CurrentItem =
    MAX ( Mapping[COA - Level 1] )
RETURN
    SWITCH (
        TRUE (),
        SEARCH ( "Gross Profit", CurrentItem,, 0 ) > 0, [Gross Profit],
        SEARCH ( "EBITDA", CurrentItem,, 0 ) > 0, [EBITDA],
        SEARCH ( "Net Profit", CurrentItem,, 0 ) > 0, [Net Profit],
        CALCULATE ( [Correct sign figure] )
    )

Thanks,

Samarth