Dummy row subtotal condition not working

[oscarmqzg]

Hi I have a measure that sums up a column, then I compare that measure to flag if it is > 0 or not, it works everywhere except and the first row. "Total" is a dummy blank column that I use just to be able to show the big total at the top. I couldn't find a reason for it or how to fix it, your help is appreciated.

[Anonymous]

Hi @oscarmqzg ,

Did you solve your problem?

The subtotal error is a common problem in Power BI Desktop.

Please refer to Greg's blog, in the blog he will talk about how to fix it with a couple of ways:

Dealing with Measure Totals - Microsoft Fabric Community

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[oscarmqzg · Accepted solution]

Thank you Stephen, it is not related to totals as it is not set up with matrix grand totals but row subtotals with a dommy total row so I can have my totals at the top as explained in this post: https://community.fabric.microsoft.com/t5/Desktop/show-grand-totals-top-bottom-of-matrix/m-p/370909

I was able to solve it using >=0.01 instead of >0 even thou my sum still shows 0.0000 when adding 4 decimals...

[Ashish_Mathur]

Hi,

What is the need of creating a dummy blank column?  Cannot understand your question.  Share the download link of the PBI file, show the problem there and the expected result.