Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
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
Merci @AlB
Cependant la formule marche bien, mais je souhaiterais avoir le total en valeur qui est de 8
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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |