ALL (as usual in PowerBI)
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
-
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!**1
Answers
-
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 any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
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.
0 -
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!**1 -
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! 😫
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive