The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I have created a financial statement in Power BI based on this method:
https://www.youtube.com/watch?v=J4317R5BvsA
I have thus created many CALCULATE measures and have used the SWITCH measure to insert these in the required order.
However, I would really like to have the subtotals and gran total calculated "inside" this table, and not calculating it separately and inserting it with SWITCH, primarily to make sure there are no mistakes in the many measures that have been created manually.
In excel, the totals are shown with a simple SUM formula. Is it possible to do something in DAX?
Screenshots for reference:
Part of my financial statement/table below. Yellow is where I would like the subtotal, red is what should be included in this subtotal.
Snippet of my SWITCH measure:
Thanks in advance!
provide a parent hierarchy according to the groupings you want, and then use HASONEVALUE and ISINSCOPE to figure out where in the hierarchy you are.
Note: Including subtotals without clear visual separation is a UX red flag.
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
34 | |
15 | |
12 | |
7 | |
6 |