Using DAX to Sum then Divide text

montyfern

montyfern

Board Regular
Joined
Oct 12, 2017
Messages
65
Hello! I'm stuck. Say I have a shelter full of dogs where I'm looking for the females in heat to quarantine them. I need to count the "0" age females, then divide that by the number of breeder status (females) for each location. I've written tons of counts, divides, even broke out calculate but am even more confused. THANKS SO MUCH!
1628884981846.png
 
Sort by date Sort by votes

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
You must log in or register to reply here.

Similar threads

I
  • Solved
DAX measure that filters a table to a single row and returns text from a specified column (Excel365)
Replies
3
Views
254
Insert_Key
I
P
  • Solved
Calculate Field in Power Pivot using DAX
Replies
3
Views
2K
powerwill
P
K
  • Solved
How to sum up working hours (a different schedule)
Replies
9
Views
325
KarolinaKaralaite
K
ajjava
  • Question Question
Procedure to find MAX VALUE in a SPECIFIC pivot table value field, in the case of MULTIPLE pivot table value fields
Replies
0
Views
2K
ajjava
ajjava
zookeepertx
  • Solved
Moving data to other columns using multiple criteria
Replies
2
Views
473
zookeepertx
zookeepertx

Forum statistics

Threads
1,223,698
Messages
6,173,897
Members
452,536
Latest member
Chiz511

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top