search

intakedesk / PowerBI-General

Placeholder for issues migrated from Jira
1 stars 0 forks source link

PIDs, TV 2.0,: Update Ovarian and Uterine attribute for Leads with new formula that considers Case Type #534

Closed jesusitd closed 4 years ago

jesusitd commented 4 years ago 
Case Talcum Ovarian Cancer = 
VAR _cases =
    SUMX(
        FILTER( Contacts, 'Contacts'[contact_id] = Leads[contact_id] ),
        CALCULATE(
            [Cases Count],
            'Cases'[Case Type] = "Talcum_Powder",
            NOT 'Cases'[Talcum Diagnosis Cancer Type]
                IN { "Uterine Cancer", "Endometrial Cancer" }
        )
    )
RETURN
    IF( _cases > 0, 1, 0 )

Case Talcum Uterine Endometrial = 
VAR _cases =
    SUMX(
        FILTER( Contacts, 'Contacts'[contact_id] = Leads[contact_id] ),
        CALCULATE(
            [Cases Count],
            'Cases'[Case Type] = "Talcum_Powder",
            'Cases'[Talcum Diagnosis Cancer Type]
                IN { "Uterine Cancer", "Endometrial Cancer" }
        )
    )
RETURN
    IF( _cases > 0, 1, 0 )

DONE 2000 DONE 3000

jesusitd commented 4 years ago

Done 8000

jesusitd commented 4 years ago

TV 2.0 DONE by @CesarITD

jesusitd commented 4 years ago

Does not apply to Azure AS.