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 September 15. Request your voucher.
Hello,
I'm having problems with the display of calculations, such as Subtotal = Revenue - Sales.
The example PBIX I've posted has a Region dimension: North, South, East West.
Maybe you can see something quickly in my layout or calculations, and hopefully you're not pulling hair out like me.
btw Thanks for all the posts I've been reading about grouping, filter, sumx, etc... It's helped me immensely so far.
Please let me know your suggestions.
PBIX attachment
https://www.dropbox.com/l/scl/AACurjwJPGnyISn_b-tfEKUjIaWX5KvgT3c
Excel attachment
https://www.dropbox.com/l/scl/AACL_wHlC87pZ3iIPUuz71CbtEoeRH1WDwQ
You may take a look at the following post.
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
User | Count |
---|---|
68 | |
63 | |
59 | |
54 | |
28 |
User | Count |
---|---|
182 | |
81 | |
63 | |
47 | |
41 |