Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calcule similarity between two item

Hi everybody !   Here is my issue : I have this set of data :   SAMU             FEATURE        Y/N SAMU 1          A                     Yes SAMU 1          B                     Yes SAMU 1 ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    Sorry for the late reply.

    Add a measure

     

    Measure =
VAR left =
    CONCATENATEX (
        VALUES ( 'left slicer' ),
        'left slicer'[SAMU],
        ","
    )
VAR right =
    CONCATENATEX (
        VALUES ( 'right slicer' ),
        'right slicer'[SAMU],
        ","
    )
RETURN
    IF (
        FIND (
            MAX ( [SAMU] ),
            left,
            1,
            0
        )
            || FIND (
                MAX ( [SAMU] ),
                right,
                1,
                0
            ),
        1,
        0
    )

     

    then modify a measure as below

     

    percent =
VAR P =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[FEATURE] ),
        FILTER (
            'Table',
            [similarity1] = 1
                && [Measure] = 1
        )
    )
        / CALCULATE (
            DISTINCTCOUNT ( 'Table'[FEATURE] ),
            FILTER (
                ALLSELECTED ( 'Table' ),
                [Measure] = 1
            )
        )
RETURN
    IF (
        ISBLANK ( P ),
        0,
        P
    )

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for your answer

     

    This look complicated .. and i dont really understand how to apply it !

     

    To start, i try to find the number of rows similar when filters are applied :

    XXX =
    CALCULATE(
    COUNTROWS(TEST);
    FILTER(TEST_2;
    TEST[SAMU]=TEST_2[SAMU]
    && TEST[ITEM] = TEST_2[ITEM]
    && TEST[CRITERE] = TEST_2[CRITERE]
    )
    )
     
    but it does not really work ..
     
    Any idea, ?