Forum Discussion

Djdjwhao's avatar
Djdjwhao
New Member
1 year ago
Solved

Exclude GL account from equity

Hi   I'm trying to get some ratios to calculate without a certain P&L GL from the equity section for certain ratios.  I was able to get that to work for a few of the ratios that has the net or oper...
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    1 year ago

    Hi Djdjwhao,

    Thank you for the follow-up question. Also, thank you for testing that out and letting us know. Since you mentioned it still did not work, could you confirm whether:
    • You are seeing the same numbers as before (filter not applying), or
    • You are running into an error message?

    To help isolate the issue, try placing the [Equity (Excluding GL 9160)] measure in a simple table along with the GLnumber column. That way, you can check if the unwanted GL account is still included.

    If the first approach did not work in your model, you could try this alternative version:

    Equity (Excluding GL 9160) =
CALCULATE(
    [Equity],
    FILTER(
        ALL(chartofaccounts),
        chartofaccounts[GLnumber] <> "000-9160-00"
    )
)

    This uses FILTER(ALL(...)) to make sure the GL account is excluded regardless of slicer context.

    Refer this link: https://learn.microsoft.com/en-in/dax/filter-function-dax

    Hope this helps. If you have any doubts regarding this, please feel free to ask here. We will be happy to help.

    Thank you for using the Microsoft Community Forum.

     

v-kpoloju-msft's avatar
v-kpoloju-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi Djdjwhao,

Thank you for the follow-up question. Also, thank you for testing that out and letting us know. Since you mentioned it still did not work, could you confirm whether:
• You are seeing the same numbers as before (filter not applying), or
• You are running into an error message?

To help isolate the issue, try placing the [Equity (Excluding GL 9160)] measure in a simple table along with the GLnumber column. That way, you can check if the unwanted GL account is still included.

If the first approach did not work in your model, you could try this alternative version:

Equity (Excluding GL 9160) =
CALCULATE(
    [Equity],
    FILTER(
        ALL(chartofaccounts),
        chartofaccounts[GLnumber] <> "000-9160-00"
    )
)

This uses FILTER(ALL(...)) to make sure the GL account is excluded regardless of slicer context.

Refer this link: https://learn.microsoft.com/en-in/dax/filter-function-dax

Hope this helps. If you have any doubts regarding this, please feel free to ask here. We will be happy to help.

Thank you for using the Microsoft Community Forum.

 

v-kpoloju-msft's avatar
v-kpoloju-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi Djdjwhao,

Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.

Thank you.

  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi Djdjwhao,

    Hope you had a chance to try out the solution shared earlier. Let us know if anything needs further clarification or if there's an update from your side always here to help.

    Thank you.

    • v-kpoloju-msft's avatar
      v-kpoloju-msft
      Icon for Community Support rankCommunity Support
      1 year ago

      Hi Djdjwhao,

      Just wanted to follow up one last time. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

      Thank you.