Forum Discussion

Harry1980's avatar
Harry1980
Helper I
4 years ago
Solved

Check for different values in the same row

Hi,   I would like to create a  measure which is checking whether a row contains different values. Actually in my company we have several affiliated entities. And it might occur that 2 (or even mor...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    The Answer is Here. 

    Measure =
VAR _count =
CALCULATE (
DISTINCTCOUNT ( 'Table (7)'[Price] ),
ALLEXCEPT ( 'Table (7)', 'Table (7)'[Material ID] )
)
RETURN
IF ( _count = 1, "FALSE", "TRUE" )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

The Answer is Here. 

Measure =
VAR _count =
CALCULATE (
DISTINCTCOUNT ( 'Table (7)'[Price] ),
ALLEXCEPT ( 'Table (7)', 'Table (7)'[Material ID] )
)
RETURN
IF ( _count = 1, "FALSE", "TRUE" )
Harry1980's avatar
Harry1980
Helper I
4 years ago

Anonymous , it is working as expected. Thank you very much. Your support is much appreciated