Forum Discussion

erezbenmoshe's avatar
erezbenmoshe
Icon for Advocate I rankAdvocate I
8 years ago
Solved

Count equal values across two rows

                                            I am trying to write a measure that counts the number of [Id] where [Total] is the same for the two [Datatype]s, method1 and me...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    erezbenmoshe

     

    Here is a MEASURE

     

    Measure =
COUNTX (
    FILTER (
        VALUES ( Table1[ID] ),
        CALCULATE ( SUM ( Table1[Total] ), Table1[Data Type] = "Method1" )
            = CALCULATE ( SUM ( Table1[Total] ), Table1[Data Type] = "Method2" )
    ),
    1
)
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Will there only be 2 data types or can there be more as well?

erezbenmoshe's avatar
erezbenmoshe
Icon for Advocate I rankAdvocate I
8 years ago

Only 2 data types