ALL (as usual in PowerBI)

bp_paulo_fernandes
bp_paulo_fernandes Member
in Charting

Hey Everyone!

 Our team is new in DOMO and we are having some issues with handling Beast Mode formulas as we did in PowerBI. DAX's ALL formula, for example.

 How do we manage in DOMO to use a denominator that ignores user-selected universe filters, like DAX's ALL does?

 We tried to use Window Functions, but it keeps considering certain filters and creating DataFlows is not a reality in our client.

Best Answer

  • GrantSmith
    GrantSmith Coach
    edited August 2021 Answer ✓

    Hi @bp_paulo_fernandes

    User filters are applied to the entire dataset, there isn't really an 'ALL' option like in Power BI. You might be able to aggregate your data via a dataflow and join that to your original dataset. This way each row would have the values from the entire dataset when each row is filtered via the user filters on the card. You can then use the aggregated column value in your beast modes.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach

    You might want to look into the new Segments feature that was released. This might work for you. Here is a link to the KB article with video.

    https://domohelp.domo.com/hc/en-us/articles/4403089503383-Creating-Segments-in-Analyzer

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • bp_paulo_fernandes
    bp_paulo_fernandes Member

    Tks for the response, Mark.

    We already testes this feature, but we need to use the "ALL" in Beast Modes.

    Many KPIs use different aggregations, like Share Of Market, for example.

  • GrantSmith
    GrantSmith Coach
    edited August 2021 Answer ✓

    Hi @bp_paulo_fernandes

    User filters are applied to the entire dataset, there isn't really an 'ALL' option like in Power BI. You might be able to aggregate your data via a dataflow and join that to your original dataset. This way each row would have the values from the entire dataset when each row is filtered via the user filters on the card. You can then use the aggregated column value in your beast modes.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • bp_paulo_fernandes
    bp_paulo_fernandes Member

    Tks @GrantSmith !

    We really think this was possible and we just doesn't know well the tool.

    Unfortunately, using Dataflows is not possible for the client! 😫

Categories