topic Re: Color code the last value in matrix hierarchy before null value in DAX Commands and Tips

Color code the last value in matrix hierarchy before null value

bharukc — Thu, 27 Oct 2022 19:47:42 GMT

I am creating a hierachy

Id level 1, level 2, level 3 level 4 level 5

1. A. B. C

2. A. D. E. F

3. M. N. O. P. Q

With the code below,

Measure = 
IF(
    ISINSCOPE('Table'[level 5]),
    IF(MAX('Table'[level 5]) = BLANK(),BLANK(),COUNT('Table'[Id])),
    IF(ISINSCOPE('Table'[level 4]),
    IF(MAX('Table'[level 4]) = BLANK(),BLANK(),COUNT('Table'[Id])),
    IF(ISINSCOPE('Table'[level 3]),
    IF(MAX('Table'[level 3]) = BLANK(),BLANK(),COUNT('Table'[Id])),
    IF(ISINSCOPE('Table'[level 2]),
    IF(MAX('Table'[level 2]) = BLANK(),BLANK(),COUNT('Table'[Id])),
    IF(ISINSCOPE('Table'[level 1]),
    IF(MAX('Table'[level 1]) = BLANK(),BLANK(),COUNT('Table'[Id]))
    ))))
    )

I was able to remove nulls in the hierarchy. I want to know if there is a way to tell the user by color coding the font of level name when it reaches the last hierarchy level before null starts.

Re: Color code the last value in matrix hierarchy before null value

daXtreme — Fri, 28 Oct 2022 07:03:15 GMT

There probably is but... Would you care to give an example? Maybe a picture of what such a thing should look like, please?

Re: Color code the last value in matrix hierarchy before null value

bharukc — Fri, 28 Oct 2022 11:55:18 GMT

daXtreme

In the picture below, C and its count, F and its count and Q and its count to be colored as red. So that people would know that is the last of hierarchy.