Forum Discussion

GTS_ONE's avatar
GTS_ONE
Advocate II
8 years ago
Solved

Can a Measure sum other rows besides itself?

Hi all,   So I know that the scenario I'm about to describe can rather easily be done by creating summary tables and joining them, etc.  But we have a particular situation where we're trying to see...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    GTS_ONE

     

    Hi, try with this measure:

     


    Does ID Have Only Blue? =
IF (
    HASONEVALUE ( Table1[ID] ),
    IF (
        SELECTEDVALUE ( Table1[Color] ) = "Blue",
        IF (
            COUNTROWS (
                FILTER ( ALL ( Table1 ), Table1[ID] = SELECTEDVALUE ( Table1[ID] ) )
            )
                = 1,
            "Yes",
            "No"
        ),
        "No"
    )
)

     

    Regards

     

    Victor

    Lima - Peru

     

GTS_ONE's avatar
GTS_ONE
Advocate II
8 years ago

Ah-ha!  Yes, that worked - thanks...