ALL (as usual in PowerBI)

bp_paulo_fernandes

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.

GrantSmith

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.

MarkSnodgrass

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

bp_paulo_fernandes

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

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.

bp_paulo_fernandes

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! 😫