SP to DAX Query

[User1406]

I want to find dax query for avg balance for the given condition....

Sum(ClosingBalance) / Case When @TotalDays = 0 Then 1 Else @TotalDays End As AverageBalance

[amitchandak · Accepted solution]

@User1406 , Assume you have total days also has measure

then divide(Sum(ClosingBalance), [Total Days],1)

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.