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" )
Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi Harry1980 ,

 

You can create a column like below :-

Column =
VAR PurOrg1 =
    TRIM ( LEFT ( [PurOrg 1], SEARCH ( " €", [PurOrg 1], 1, 0 ) ) )
VAR PurOrg2 =
    TRIM ( LEFT ( [PurOrg 2], SEARCH ( " €", [PurOrg 2], 1, 0 ) ) )
VAR PurOrg3 =
    TRIM ( LEFT ( [PurOrg 3], SEARCH ( " €", [PurOrg 3], 1, 0 ) ) )
VAR PurOrg4 =
    TRIM ( LEFT ( [PurOrg 4], SEARCH ( " €", [PurOrg 4], 1, 0 ) ) )
RETURN
    IF (
        PurOrg1 = PurOrg2
            && PurOrg1 = PurOrg3
            && PurOrg1 = PurOrg4,
        TRUE (),
        FALSE ()
    )

Output:-

 

Thanks,

Samarth