Forum Discussion

luigui's avatar
luigui
New Member
7 years ago
Solved

Text measure

Hi,   I have 3 tables in a simple model:   1) Customer dimension:   Customer Id Customer Name C1       Customer 1 C2       Customer 2 C3       Customer 3 C4       Customer 4     2) F...
  • MFelix's avatar
    MFelix
    7 years ago

    Hi luigui,

     

    Measures are based on context, since your are making the table based on the customer table it will return all the values from that table and then calculate the measure you created in this case returns "NOT OK" result.

     

    Redo your measure to this:

    Measure_Ok =
IF (
    SUM ( F1[Value F1] ) = BLANK ()
        && SUM ( F2[Value F2] ) = BLANK ();
    BLANK ();
    IF (
        SUM ( F1[Value F1] ) <> BLANK ()
            && SUM ( F2[Value F2] ) <> BLANK ();
        "Ok";
        "Not ok"
    )
)

     

    Should remove the C4 customer.

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
7 years ago

Hi luigui,

 

Measures are based on context, since your are making the table based on the customer table it will return all the values from that table and then calculate the measure you created in this case returns "NOT OK" result.

 

Redo your measure to this:

Measure_Ok =
IF (
    SUM ( F1[Value F1] ) = BLANK ()
        && SUM ( F2[Value F2] ) = BLANK ();
    BLANK ();
    IF (
        SUM ( F1[Value F1] ) <> BLANK ()
            && SUM ( F2[Value F2] ) <> BLANK ();
        "Ok";
        "Not ok"
    )
)

 

Should remove the C4 customer.

 

Regards,

MFelix