Forum Discussion
jahnabi123
5 years agoNew Member
Dax calculation for DIVIDE
I am facing a very strange issue. I have 2 measures both data type decimal. I am dividing one by the other. Now, even if both the measures have the same value, the result is not 1. This is the dax:...
amitchandak
5 years agoSuper User
jahnabi123 , can share formula for
[Total Households],[Total Household cust]
jahnabi123
5 years agoNew Member
Total Household = SUM(account_history[a_se_hh_tot])
Total Household cust = CALCULATE(SUM(account_history[a_se_hh_tot]), ALL(account_history[CEM], account_history[Fee Model], account_history[funding_type_code],account_history[cohort_golive2],account_history[date_golive], account_history[customer_name], account_history[employer_name] ))