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.
Hi,
Please help me with Power BI DAX.
I have strugling to create DAX to count total number of Child who has absent 3 or more days every month.
Please help me.
I have attached my cleaned data on this link:
Thank you for your help
Solved! Go to Solution.
# Child Absent 3+ Days =
COUNTROWS(
FILTER(
VALUES( AttendanceMaster[ChildID] ),
CALCULATE(
COUNTROWS( AttendanceMaster ) >= 3,
KEEPFILTERS( NOT AttendanceMaster[IsPresent] )
)
)
)
Best
D
Hi there.
I've had a look at the file. I think many of those measures are incorrect (and will not work correctly in many filtering conditions) but I might be wrong and from your point of view they are correct. Not sure but my experience tells me they are not right.
However, regardless of the above, I think you're after such a measure:
# Children 10%-20% =
COUNTROWS(
FILTER(
VALUES( AttendanceMaster[ChildID] ),
.1 < [% of Absent Child]
&&
[% of Absent Child] <= .2
)
)
If this does not work, you have to create a measure (in place of [% of Absent Child]) that will calculate the percentage of time that a child was absent IN ANY SETTING. Please bear in mind that the measure should work correctly under any circumstances. If it's not, then the calculation is wrong as well.
Hope this helps.
Best
D
Hi @Anonymous ,
I have updated the pbix please look at attachment and this pictute:
In Values I have added this DAX:
# of Absent = CALCULATE(COUNTA (AttendanceMaster[ChildID], FILTER (AttendanceMaster,AttendanceMaster[IsPresent] = FALSE ()))
I want to measure total ChildID who have values 3 or more days every month. So that I have to created this DAX but does not work.
# of ChildID Absent 3 or more days = CALCULATE(COUNTA (AttendanceMaster[ChildID], FILTER (AttendanceMaster,[# of Absent] >= 3))
Please look at this link:
Thank you
@Anonymous ,
Thank you. You have found solution for me.
In other case, I have Strugling to calculate total Child who has absent greater than 10% to less than or equal 20%.
Please look at this picture:
In Values, I have created this measure:
# of Absent Child = CALCULATE (COUNTA('AttendanceMaster'[ChildID], 'AttendanceMaster[IsPresent] IN { FALSE })
After that I created this measure too:
# of Child Days = CALCULATE(COUNT('AttendanceMaster'[ChildID]))
Than I created this measure also:
% of Absent Child = CALCULATE(DIVIDE([# of Absent Child],[# of Child Days]))
I want to measure total count of Child who has absent >10% to <=20% every month.
Can you help me again for the last?
I have attach pbix on this link. Please look that data:
Thank you for your help
Best
Hi there.
I've had a look at the file. I think many of those measures are incorrect (and will not work correctly in many filtering conditions) but I might be wrong and from your point of view they are correct. Not sure but my experience tells me they are not right.
However, regardless of the above, I think you're after such a measure:
# Children 10%-20% =
COUNTROWS(
FILTER(
VALUES( AttendanceMaster[ChildID] ),
.1 < [% of Absent Child]
&&
[% of Absent Child] <= .2
)
)
If this does not work, you have to create a measure (in place of [% of Absent Child]) that will calculate the percentage of time that a child was absent IN ANY SETTING. Please bear in mind that the measure should work correctly under any circumstances. If it's not, then the calculation is wrong as well.
Hope this helps.
Best
D
# Child Absent 3+ Days =
COUNTROWS(
FILTER(
VALUES( AttendanceMaster[ChildID] ),
CALCULATE(
COUNTROWS( AttendanceMaster ) >= 3,
KEEPFILTERS( NOT AttendanceMaster[IsPresent] )
)
)
)
Best
D
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 |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |