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.
Hello
I try to figure out to do one simple thing and I would greatly appreciate any help.
I have a table like this :
Calendrier.[DATE] | Calendrier.[Duration] |
dd/mm/YYYY | 7 |
dd/mm/YYYY | 7,5 |
dd/mm/YYYY | 8 |
dd/mm/YYYY | 7,5 |
... | ... |
I would like to count the number of lines where the value equals 7,5 and the total number of lines.
Thank you for your help
Solved! Go to Solution.
Thank you so much for your solution.
Makes me want to quickly improve my skills with powerBI.
Total Lines = COUNTROWS(Calendrier)
7,5 lines = CALCULATE ( COUNTROWS(Calendrier), KEEPFILTERS(Calendrier[Duration] = 7,5 ) )
Hello thank you for your help.
The first formula works fine but the second doesn't, because I wasn't precise enough, I'm sorry.
My table is built like this :
- a date --> a duration
- a date --> a duration
- a date --> à duration
Sometimes, the date is the same (i can have several recording for, let's say, 2020/04/01 and I printed the total sum of the duration for this date).
That means i summed up several recordings to obtain this result.
Calendrier.[DATE] | Calendrier.[Duration] |
dd/mm/YYYY | 7 |
dd/mm/YYYY | 7,5 |
dd/mm/YYYY | 8 |
dd/mm/YYYY | 7,5 |
... | ... |
Now I would like to have the number of lines where the sum of the duration, for each day, equals 7,5.
I really hope my explanations were clear enough.
Best regards
Thank you so much for your solution.
Makes me want to quickly improve my skills with powerBI.
In my example I have a measure called [DurationSum]
DurationSum = SUM ( Calendrier[Duration] )
Then this measure will count the rows where DurationSum = 7,5
7,5 count =
COUNTROWS (
FILTER (
ADDCOLUMNS ( VALUES ( Calendrier[Date] ), "x", [DurationSum] ),
[x] = 7,5
)
)
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |