Forum Discussion

przwrz1's avatar
przwrz1
New Member
5 years ago

Power Bi Matrix - hide rows if total is zero

Hi,

 

I've created simple aged receivables report following also this tutorial  https://www.sqlbi.com/articles/grouping-transactions-by-age-of-customers-in-dax/. But there are situations that the payment for the invoice is not yet reconcile with the amount due, so I have in one bucket invoice amount (e.g 60-90 days) and the payment in another one (eg. 0-30 days). In Totals is zero, which is correct value. How may I hide all rows where total is zero regardless data in the certain buckets?

 

P.

2 Replies