Need help to set column value as Zero for specific row of matrix table

[ashish_18]

Hi Team,

I am trying to replace value of column estimated Funding to zero for rows having description as "Capco" and "Connex SOW -- Non SRE"  These rows are coming from field "Description" and value is ProjectCost.

I have tried creating column Test but resut is giving zero value to Total of category "CCS Staff Augmenation" too. Category is another row of matrix table. 

Test = IF(('ClarityMaster'[Description]="Capco") || ('ClarityMaster'[Description]="Connex SOW -- Non SRE"),

0,'ProjectEstimate'[ProjectCost])

CCS Staff Augmenation  should be 1114727 and description rows "Capco" and "Connex SOW -- Non SRE" should show 0.

Really appreciate if anybody can help here !!

[Jihwan_Kim · Accepted solution]

Hi, 

I am not sure how your semantic model looks like, but I assume you tried to create calculated column.

Please try creating measure, something like below.

I tried to create a sample pbix file like below, and please check the below picture and the attached pbix file.

Test measure: = 
SWITCH (
    TRUE (),
    ISINSCOPE ( ClarityMaster[description] ),
        IF (
            MAX ( ClarityMaster[description] ) = "Capco"
                || MAX ( ClarityMaster[description] ) = "Connex SOW -- Non SRE",
            0,
            SUM ( ClarityMaster[funding] )
        ),
    SUM ( ClarityMaster[funding] )
)

[ashish_18]

Thank you so much for your insights @Jihwan_Kim  I will try with this code and let you know if any issues.. Thanks again!!