Forum Discussion

Ashishvca's avatar
Ashishvca
Frequent Visitor
4 years ago
Solved

Calculated measure not working after publishing

Hi   I am using calculated measure which are working fine on desktop but not working after I publish them.  Here is the formula I am using  Direct Selling = -(CALCULATE(sum(Consolidated[USD]),(Co...
Need Help
  • edhans's avatar
    edhans
    4 years ago

    You have more parentheses than you need. Two extra sets. Try this:

    Direct Selling =
- CALCULATE(
    SUM( Consolidated[USD] ),
    Consolidated[Account] = "Direct_Selling"
)

    If that fails, then I'd need to see the model image.

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
4 years ago

You have more parentheses than you need. Two extra sets. Try this:

Direct Selling =
- CALCULATE(
    SUM( Consolidated[USD] ),
    Consolidated[Account] = "Direct_Selling"
)

If that fails, then I'd need to see the model image.