Forum Discussion
How can we calculate row values for a row depending upon values in remaining row
I want to calculate the missing values for the row New Department which has the following calculation which is based on the values in other rows. Department Sub-Department Col1 Col2 Mont...
v-sihou-msft
Microsoft Employee
Microsoft Employee
As Sean said, DAX can never work on cell level. And in this scenario, your table should include the fact data for lowest grain only so that you only need to aggregate the data for grand total. It's not a good practice to keep a records for "All" in the table. I suggest you separate this row into another table.
If you really need to do calculation on cell level, I suggest you use Excel.
Regards,
Thanks v-sihou-msft. We did the calculations at the sql query level for now as we could not find any way to do it at the Power BI level.