Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a visual whenre I add Number of People against Areas. If the total is less than wo I dont display it.
I have some DAX that counts the less than or equal to 10s
Solved! Go to Solution.
@DebbieE , Hope [Total People] is just a sum measure not using all or allselected. If all and all selected are not used then if the measure used anything other than area, then it will give data that will consider that row context too
based on what I got
so your total measure can be
= calculate(Count(Table[People]), filter(allselected(Dim Person), 'Dim Person'[Area] = Max('Dim Person'[Area]) ) )
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@DebbieE , Hope [Total People] is just a sum measure not using all or allselected. If all and all selected are not used then if the measure used anything other than area, then it will give data that will consider that row context too
based on what I got
so your total measure can be
= calculate(Count(Table[People]), filter(allselected(Dim Person), 'Dim Person'[Area] = Max('Dim Person'[Area]) ) )
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
User | Count |
---|---|
93 | |
87 | |
77 | |
72 | |
66 |
User | Count |
---|---|
116 | |
107 | |
88 | |
65 | |
63 |