Hasonevalue - hierarchy Level

[sandee]

Hello Experts,

Need your help -  i have data of clients with Due dates, i am showing these details in metrics table.

the problem for every client the no of due days is getting sum (which is ofcourse), then i applied HASONEVALUE measure.

it solve my one problem but if i am further going inside or drill the metrics table then i see the same result everywhere.

Measure Used: 

Testing 1 = IF(HASONEVALUE('AP Supplier - Days Due'[Days Due]),

                                   IF(VALUES('AP Supplier - Days Due'[Days Due])>=0,

                                          VALUES('AP Supplier - Days Due'[Days Due])

                                      ),

"Overdue"

)

please can you advise , what is the best solution in this case. many thanks

[Fowmy]

@sandee 

You can turn off the subtotal for the matrix as shown below. If you want to selectively do it, you find the last option "Per-Row".