Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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/
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 50 | |
| 49 | |
| 35 | |
| 15 | |
| 14 |
| User | Count |
|---|---|
| 91 | |
| 75 | |
| 41 | |
| 26 | |
| 25 |