Hasonevalue - hierarchy Level

Question

Hello Experts,&nbsp;Need your help -&nbsp; 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.&nbsp;it solve my one problem but if i am further going inside or drill the metrics table&nbsp;then i see the same result everywhere.&nbsp;Measure Used:&nbsp;Testing 1 = IF(HASONEVALUE('AP Supplier - Days Due'[Days Due]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;IF(VALUES('AP Supplier - Days Due'[Days Due])&gt;=0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VALUES('AP Supplier - Days Due'[Days Due])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),"Overdue")&nbsp;&nbsp;&nbsp;&nbsp;please can you advise , what is the best solution in this case. many thanks&nbsp;&nbsp;

fowmy · Answer

sandee&nbsp;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".

&nbsp;

Forum Discussion

Hasonevalue - hierarchy Level

1 Reply

Related content

Matrix Visual Hierarchy Level Problem

Multi level hierarchy in Gantt chart by microsoft corporation

Dynamic Y range visual calculation in two level hierarchy

Matrix Hierarchy - Show blank rows at upper level but not lower level

Matrix Show Different Hierarchy Levels