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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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/
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 39 | |
| 37 | |
| 29 | |
| 24 |
| User | Count |
|---|---|
| 122 | |
| 111 | |
| 83 | |
| 69 | |
| 68 |