Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter on measure

Hey everyone,    Is there a way to count rows or distinctcount the articles where difference <0 ? Difference is a measure, based on several other measures.  I only need one return with 3 as result...
Need Help
  • goncalogeraldes's avatar
    goncalogeraldes
    4 years ago

    Hello there Anonymous ! Not sure if this is what you need but:

    Measure = 
CALCULATE(
    COUNTROWS( 
        FILTER(
            SUMMARIZE(
                'Articles',
                'Articles'[Aggregation_criteria],
                "Diff", [Difference]
             ),
            [Difference] < 0
        )
    )
)

    Hope this answer solves your problem!
    If you need any additional help please @ me in your reply.
    If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
    Thanks!

    You can also check out my LinkedIn!

    Best regards,
    Gonçalo Geraldes

goncalogeraldes's avatar
goncalogeraldes
Icon for Super User rankSuper User
4 years ago

Hello there Anonymous ! Not sure if this is what you need but:

Measure = 
CALCULATE(
    COUNTROWS( 
        FILTER(
            SUMMARIZE(
                'Articles',
                'Articles'[Aggregation_criteria],
                "Diff", [Difference]
             ),
            [Difference] < 0
        )
    )
)

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes