Forum Discussion

p0nk's avatar
p0nk
Frequent Visitor
7 years ago
Solved

Compare value against target range for multiple entries

Hello,   I currently have the following table within Power BI: The blue columns are the categories that I would like to use, the red column is the count of each entry for the repective categ...
Need Help
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    Hi p0nk ,

    We can create a measure like below:

    Measure =
IF (
    MIN ( Table1[Category] ) = "A",
    IF ( [% of distribution] >= 0 && [% of distribution] <= 0.05, "No", "Yes" ),
    IF (
        MIN ( Table1[Category] ) = "B",
        IF ( [% of distribution] >= 0.7 && [% of distribution] <= 0.9, "No", "Yes" ),
        IF ( [% of distribution] >= 0.1 && [% of distribution] <= 0.2, "No", "Yes" )
    )
)

    The result will like below:

    Best Regards,

    Teige

TeigeGao's avatar
TeigeGao
Icon for Solution Sage rankSolution Sage
7 years ago

Hi p0nk ,

We can create a measure like below:

Measure =
IF (
    MIN ( Table1[Category] ) = "A",
    IF ( [% of distribution] >= 0 && [% of distribution] <= 0.05, "No", "Yes" ),
    IF (
        MIN ( Table1[Category] ) = "B",
        IF ( [% of distribution] >= 0.7 && [% of distribution] <= 0.9, "No", "Yes" ),
        IF ( [% of distribution] >= 0.1 && [% of distribution] <= 0.2, "No", "Yes" )
    )
)

The result will like below:

Best Regards,

Teige