Calculate Totals for each Court using a fixed Denominator

[pfarahani]

Hello ALL.

I have a basic measure to start that gives me total filings, total number of filed cases. I have a basic table that breaks that down by each Court location, below

What I am trying to do next is to find the average for each Court based on a fixed number of Departments. For example, Stanley Mosk has 5 departments, so the denominator will be 5. 138,435 filings divided by 5, and so on for each Court. Pomona has 10, so 21,681/10. And so on. How can I get this? The other things also, is that it should tie to the slicer. If the user selects Pasadena, it should display the number for Pasadena Court

[Joseph_Collins_]

That’s an interesting point you made, and I agree that more clarity in public case access is definitely needed. For those seeking accurate and up-to-date court-related details, the Bexar Administration-directory resource can be very useful. It provides comprehensive insights that can help people stay informed about legal processes. I’d suggest checking it out if you need deeper case insights or want to track updates efficiently.

[GraceAllen]

You can achieve this by creating a calculated column or measure that uses a lookup table to associate each court with its fixed number of departments, then divide the total filings by that number. Also, ensure your slicer is properly filtering the visual context. If you're working on organizing gift-related events or office holiday planning alongside this, you might find this Gift matcher online handy—it simplifies group coordination and ensures everyone gets matched efficiently. Let me know if you need help setting up the DAX expression for this logic. 

[jassica_alba]

That sounds incredibly frustrating, especially given the time and money already spent. If you’re considering taking legal action or want to gather more background on similar cases, exploring a detailed Maryland case lookup might help you see how comparable disputes have been handled. Sometimes seeing actual case outcomes can offer useful direction before heading to small claims or seeking legal advice.

[Anonymous]

Hi  @pfarahani ,

Here are the steps you can follow：

1. Create measure.

Measure =
VAR _denominator=COUNTX(FILTER(ALL('Table'),'Table'[CourthouseAbbreviation]=MAX('Table'[CourthouseAbbreviation])),[CourthouseAbbreviation])
RETURN
DIVIDE([Filings Count_MEASURE],_denominator)

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[tamerj1 · Accepted solution]

Hi @pfarahani 

you can divide by

COUNTROWS ( VALUES ( TableName[Department] ) )

[martin_gayle34]

Really appreciate the clarity in this update—breaking down how totals are calculated with a fixed denominator helps make the process much easier to follow. It’s interesting to see how these changes could influence future evaluations and comparisons across regions. While going through similar topics, I found Pork County Judiciary useful for understanding related procedural details. Thanks for opening the discussion and inviting public input.https://polkcountycourts.org