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

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
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
428
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
474
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
488
zookeepertx
zookeepertx

Forum statistics

Threads
1,225,535
Messages
6,185,501
Members
453,298
Latest member
Adam1258

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