Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Here is the link to the data set i am working with
https://drive.google.com/file/d/0B0XwYvmbIN12S25wQTRtVUhIaVE/view?usp=sharing
Hello power BI experts. Hope you are doing great!! I am having a slight issue with calculating a measure. I have revenue and expenses as rows. What i need to get is a measure named grand total which should be equal to revenue-direct expense-operating expense+other income. How can i achieve that based on the data i have? Also i need to have the grand total measure as a row in the report. Thanks a lot. A prompt solution will be highly appreciated. Thanks again
Can you simplify your data model? I wonder if a calculated column helps.
Column = IF ( 'Table'[Type] IN { "Direct Expenses", "Operating Expenses" }, - 'Table'[Amount], 'Table'[Amount] )
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |