The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. 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/
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
78 | |
66 | |
52 | |
50 |
User | Count |
---|---|
121 | |
120 | |
78 | |
63 | |
62 |