Forum Discussion

Hussein_charif's avatar
Hussein_charif
Icon for Helper V rankHelper V
1 year ago
Solved

return matrix values only on item level

i have a matrix that has the rows itemNo, year,month,day.

i am using a measure to return itemNo difference % which i got from the fabrics community that works exactly to my desire, except that i want to only show the values on the item level.

here is my measure :

item difference % =
IF(
    ISINSCOPE(table[itemNo]),
    CALCULATE(
        [Difference %],
        ALLEXCEPT(table, table[itemNo])
    ),
    BLANK() 
)
here is what it shows : 
and what i want :
the way i did that one above is by making the row subtotals text color white, but if i drill up to show only the item no, the item difference % becomes white.

what can i do to achieve the same result as the second image without using the row subtotals color change?
Need Help
Show and Tell
Tips and Tricks
  • johnt75's avatar
    johnt75
    1 year ago

    You could use

    item difference % =
IF (
    ISINSCOPE ( table[itemNo] ) && NOT ISINSCOPE ( 'Date'[Year] ),
    CALCULATE ( [Difference %], ALLEXCEPT ( table, table[itemNo] ) )
)

2 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    1 year ago

    You could use

    item difference % =
IF (
    ISINSCOPE ( table[itemNo] ) && NOT ISINSCOPE ( 'Date'[Year] ),
    CALCULATE ( [Difference %], ALLEXCEPT ( table, table[itemNo] ) )
)