Forum Discussion

Juju-PowerBI's avatar
Juju-PowerBI
Frequent Visitor
5 years ago
Solved

Filter count

  Bonjour   Je souhaiterais untiliser une mesure, avec la fonction COUNT, mais selon un filtre, compter les books pour lesquelles la valeur est supérieur à 4   Comment faire ?   Merci
Help me
  • AlB's avatar
    AlB
    5 years ago

    Juju-PowerBI 

    You're right:

    Measure V2 =
COUNTROWS (
    CALCULATETABLE (
        Table1,
        TREATAS (
            FILTER ( DISTINCT ( Table1[Book] ), CALCULATE ( COUNT ( Table1[Book] ) ) >= 4 ),
            Table1[Book]
        )
    )
)

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

     

AlB's avatar
AlB
Community Champion
5 years ago

Juju-PowerBI 

You're right:

Measure V2 =
COUNTROWS (
    CALCULATETABLE (
        Table1,
        TREATAS (
            FILTER ( DISTINCT ( Table1[Book] ), CALCULATE ( COUNT ( Table1[Book] ) ) >= 4 ),
            Table1[Book]
        )
    )
)

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers