topic Re: Dax formula in DAX Commands and Tips

Dax formula

EKI — Fri, 25 Oct 2024 12:09:37 GMT

Dear all,

I'm new to the Power BI environment so be patient with me.

I have created a report for my project financial overview.

I have a matrix table where the rows are the project hierarchy (main and subs) in a nested layout.

In columns i have the Contracted amount, Invoiced amount, budget, costs etc.

Now i have created a measure that will calculate the unbilled amount based on my cost progress (if result=<0,0,result).

My issue there is that in the total row of the table it will not sum the results of the lines (Green) but it will calculate the value based on the total line results (Red).

Does anyone knows a trick or a different type of calculation i could make, in order to not change the visual i have currently?

Re: Dax formula

lbendlin — Fri, 25 Oct 2024 19:49:56 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Dax formula

Anonymous — Mon, 28 Oct 2024 03:24:16 GMT

Hi EKI ,

Do you mean that the total of the measure column is incorrect? I recommend you create another measure with SUMX function and use it in matrix. The measure column with the correct total should then appear, you just need to hide the original measure column.

Measure = SUMX('Table',[Unbilled amount])

If I'm not understanding the problem correctly, please provide more information such as sample data, dax of measure or link of pbix file.

Best regards,

Mengmeng Li