How to do division, based on condition

[TriveniN]

Source data

Name	DaysInPeriod(measure)
A	92
A	92
A
B
B	92
C	92

Expected output:  we need to group name based only if DaysInPeriod(measure) has value.

Here in this case count(name), where daysin period has value is 2 and it should be divided by daysIn Period/2

Name	DaysInPeriod(measure)	Count	Output
A	92	2	92/2=46
A	92	2	92/2=46
A
B
B	92	1	92/1=92
C	92	1	92/1=92

Help me out to get this

[TriveniN]

@lbendlin : Can you help me out to get that mentioned output 

[DOLEARY85]

Hi,

try creating a measure to work out the count then another to calculate the divide. You can combine them after you know it's working if needed.

measure 1 = CALCULATE(count('Table'[DaysInPeriod(measure)]),ALLEXCEPT('Table','Table'[Name]))

Measure 2 = DIVIDE(CALCULATE(max('Table'[DaysInPeriod(measure)])),[measure 1])

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[TriveniN]

Thanks for response .

Here DaysInPeriod(measure) is the measure, we can't apply count for measure right?

[DOLEARY85]

Ah okay, for the first measure try:

measure = if(not(ISBLANK([DaysInPeriod(measure)])),CALCULATE(COUNT('Table'[Name])),BLANK())

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[TriveniN]

Its not working out.