DAX format formula error

[Anonymous]

Hi Experts

I cannot see the error on the following DAX...

TEST 111 = FORMAT(CALCULATE([Total Revenue], FILTER('Product','Product'[Sub Brand] IN {"ESTEEM+ CONVEX DRAINABLE","ESTEEM+ FLAT CLOSED","ESTEEM+ FLAT DRAINABLE","ESTEEM+ FLAT MOLDABLE CLOSED","ESTEEM+ FLAT MOLDABLE DRAINABLE"}),"$#,##0.0;($#,##0.0)"))

[affan · Accepted solution]

Hi @Anonymous

Please try the measure as below 

TEST 111 = 
    FORMAT(CALCULATE([Total Revenue], 
            FILTER('Product','Product'[Sub Brand] 
                    IN {"ESTEEM+ CONVEX DRAINABLE","ESTEEM+ FLAT CLOSED","ESTEEM+ FLAT DRAINABLE","ESTEEM+ FLAT MOLDABLE CLOSED","ESTEEM+ FLAT MOLDABLE DRAINABLE"})
)
,"$#,##0.0;($#,##0.0)")

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

Regards,

Affan

[Anonymous]

thamks, much apprciated for the feedback