This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
Hello Team,
In need of some help here. I would like to have the numbers add up correctly.
The date columns are from a date table. The rows are from a Customer table.
The values are from a third table which are transactions. If in a quarter there is a transaction it shows 1/4. So i would like to have added it up to the total. For example the second line i would like to display total 2021 as 0.75.
Ideally the column totals at the bottom would be the percentage of grand total per year.
Solved! Go to Solution.
@JayRooster , you can use isinscope and switch the grand total
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
@JayRooster , you can use isinscope and switch the grand total
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 28 | |
| 23 | |
| 22 | |
| 16 | |
| 16 |
| User | Count |
|---|---|
| 61 | |
| 35 | |
| 29 | |
| 23 | |
| 22 |