We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
Hi all,
Is there a limit to the number of separate calculation groups I can have in one tabular model?
Current Calculation Group:
| Measure | Order |
| Actuals MTD | 1 |
| Budget MTD | 2 |
| Actuals QTD | 3 |
| Budget QTD | 4 |
I now need to have a calculation group like this:
| Measures | Order |
| Actuals MTD | 1 |
| Actuals QTD | 2 |
| Actuals YTD | 3 |
| Budget MTD | 4 |
| Budget QTD | 5 |
| Budget YTD | 6 |
Should I just add a sort column to the existing calculation group or should I make a second calculation group and have both in the Tabular model?
Thanks!
Solved! Go to Solution.
Found a solution:
Looks like you can have multiple calculation groups in one power bi model.
Kudos to this video: https://www.youtube.com/watch?v=LLZYvz5bxkM
Found a solution:
Looks like you can have multiple calculation groups in one power bi model.
Kudos to this video: https://www.youtube.com/watch?v=LLZYvz5bxkM
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |