topic Filter count in DAX Commands and Tips

Filter count

Juju-PowerBI — Thu, 21 Jan 2021 16:14:39 GMT

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

Re: Filter count

AlB — Thu, 21 Jan 2021 17:51:01 GMT

Hi Juju-PowerBI

It would help if you showed the actual expected result.

Try this in a card visual

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

Re: Filter count

Juju-PowerBI — Mon, 25 Jan 2021 08:41:24 GMT

Bonjour AlB

Il semble que mes références peuvent etre différentes, comme ci dessous

Je suis à la recherche d'une mesure me permettant comter les Books celon un filtre

Quand pensez vous ? merci

Re: Filter count

AlB — Mon, 25 Jan 2021 09:22:37 GMT

Juju-PowerBI

1. Place Book in a table visual

2. Place this measure in the table visual

Measure = COUNT ( Table1[Book] )

3. Use [Measure] as a filter for the table visual, choosing to show when value is >= 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

Re: Filter count

Juju-PowerBI — Mon, 25 Jan 2021 10:34:48 GMT

Bonjour AlB

J'ai essayé cette solution, mais je souhaiterais l'incorporer dans une mesure pour pouvoir comparer au total

Peut être que cet exemple serait mieux

Merci

Re: Filter count

AlB — Mon, 25 Jan 2021 11:02:25 GMT

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

Re: Filter count

Juju-PowerBI — Mon, 25 Jan 2021 11:55:17 GMT

Merci AlB

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

Re: Filter count

AlB — Mon, 25 Jan 2021 14:26:51 GMT

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