Forum Discussion

Ulal's avatar
Ulal
New Member
3 years ago

Divide Two Measures which has filters

Hi Team, i am facing issue in dividin two measures which has row level filters on it. when iam trying DIVIDE function its throwing me error. Help me out here.

Measure 1 = COUNTROWS(FILTER(ADDCOLUMNS(SUMMARIZE('SV Demo','SV Demo'[NationalIdNo],"Distinctpolicies", DISTINCTCOUNT('SV Demo'[PolicyTypeCd])), "policycount", [Distinctpolicies]), [policycount] =2)).

Measure 2 = CALCULATE(DISTINCTCOUNT('SV Demo'[NationalIdNo]),'SV Demo'[PolicyTypeCd] = "BE")

Measure 3 = CALCULATE(DISTINCTCOUNT('SV Demo'[NationalIdNo]), 'SV Demo'[PolicyTypeCd] = "BI")

Measure 4 = Distinctcount('SV Demo'[NationalIdNo]).

 

I need 3 New measures by Dividing (1st measure with 4th Measure) ,  (2nd Measure with 4th Measure),  (3rd Measure with 4th Measure)

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Ulal , these measures should work, please share error you are getting

     

    Divide([Measure 1],[Measure 4])

     

    Divide([Measure 2],[Measure 4])

     

    Divide([Measure 3],[Measure 4])