Forum Discussion

truttafisker's avatar
truttafisker
Icon for Helper II rankHelper II
2 years ago

Coloring matrix dependant on sub row values

I have a matrix with values and everything works ..  But I would like to have a columns that on the toplvl of the row (do not know the correct term), shows if there is one of the sub-rows that has a...
ahadkarimi's avatar
ahadkarimi
Icon for Solution Specialist rankSolution Specialist
2 years ago

Hi truttafisker, give this a try, and if you encounter any issues, let me know.

Add a new measure. Assuming the sub-row values are in a column called AmountThisYear, use this DAX formula:

 

HasLowValue = 
IF(MINX(FILTER(TableName, TableName[Customer] = SELECTEDVALUE(TableName[Customer])), TableName[AmountThisYear]) < 10, 1, 0)

 

Did I answer your question? If so, please mark my post as the solution! ✔️
Your Kudos are much appreciated! Proud to be a Solution Specialist!

  • truttafisker's avatar
    truttafisker
    Icon for Helper II rankHelper II
    2 years ago

    it might work .. the only problem now is that I get all the vendors, instead of the vendors where there are revenue .. 

  • truttafisker's avatar
    truttafisker
    Icon for Helper II rankHelper II
    2 years ago

    tried it .. but didn't work