To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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/
User | Count |
---|---|
77 | |
67 | |
65 | |
50 | |
27 |