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 

It looks like we're running in circles. For that you just need what I already offered as first solution, on a card visual. So I am repeating myself here:

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

 

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 

 

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

    Merci AlB 

     

    Cependant la formule marche bien, mais je souhaiterais avoir le total en valeur qui est de 8