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.
G'day BI'ers....
Hope you're well. Wondering if I can pick you're brains.
Issue:
I am trying to sum the total number of time slots per day used (shown in the image below), to be entered into a simple card.
The result should equal 12 when unfiltered, but adapt to any filter function added, changing this value accordingly.
Is there a function or DAX measure that can be written to count this number?
If further evidence is please let me know what may help and I will provide it.
Kind regards and thanks for your time.
Computron.
Solved! Go to Solution.
I have no idea how you would want to calculate desk utilization. I'm just here to help get you the result you're looking for. In this case, 12 for the data you provided.
DeadDeskDenom = COUNTROWS( SUMMARIZE(FILTER('WUA BI App Export', 'WUA BI App Export'[Status]="Dead"), 'WUA BI App Export'[Day], 'WUA BI App Export'[SurveyID]) )
Depending on how your report is set up, you may be able to remove the FILTER from within the summarize, if you have a slicer or filter that is already applying the Status="Dead" filter to the card.
How are the values determined in the first place? Is it some sort of sum or count?
Hi Cmcmahan,
Thanks for taking an interest in my query.
The values shown in the matrix are produced through a countrows measure:
"DeadDeskCounter = calculate(countrows('WUA BI App Export'),'WUA BI App Export'[Desk Status] = "Dead")"
Background:
The purpose of my request is to generate a denumerator with I can calcuate the average number of dead desks in a building for a workplace utilisation study.
Of course if I am barking up the wrong tree please let me know.
Kind regards,
Computron.
I have no idea how you would want to calculate desk utilization. I'm just here to help get you the result you're looking for. In this case, 12 for the data you provided.
DeadDeskDenom = COUNTROWS( SUMMARIZE(FILTER('WUA BI App Export', 'WUA BI App Export'[Status]="Dead"), 'WUA BI App Export'[Day], 'WUA BI App Export'[SurveyID]) )
Depending on how your report is set up, you may be able to remove the FILTER from within the summarize, if you have a slicer or filter that is already applying the Status="Dead" filter to the card.
Worked like a charm, thanks for the suggestion.
(The background was only meant to flesh out why I made the request, not to influence how you would choose to solve my issue).
I'll mark this as a solution.
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |