Zantac PIDS: Change CPS Ranges to $500 and $800

Task List:

[x] Ads Performance Categories measures (Tier)
[x] Change SlicersAdsBucketsTitles query
[x] Change Slicer Ads Bucket Title measure
[x] Change To Convert measure

PIDs:

[x] 2000
[x] 3000
[x] 6000
[x] 8000
[x] x - PID Drillthrough
[x] Azure Analysis Services


VAR _leadType = SELECTEDVALUE ( LeadVendorCampaigns[Lead Type] )
VAR _threshold1 = SWITCH ( _leadType, "Talcum", 2000, "Roundup", 1500, "Hernia Mesh", 500, "Zantac", 500, 1000 )
VAR _threshold2 = SWITCH ( _leadType, "Talcum", 3000, "Roundup", 2000, "Hernia Mesh", 800, "Zantac", 800, 1300 )

SlicerAdsBucketsTitles

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("vdK7DoIwGAXgV/nTwAamLRJlNA4u3hI1DMhApGIHKSno89uWUaqpUUfgfDnNoVmGCArQXjSwZfIs5JXXFczKFkKYi/rO5AiON4wjBhT7tuShgU6ARzDGSrWdTsCOVzUr35HYmVD3FveSIZEHGaLKrXhpH4vEvnrqtxoMmpVCj9AkGTiThcSGJA6EmhbqQkzJ5BtALxUplgrZf3hxsU56MnvWI5H6FRsJC8mKTlU8H84mzUX5SEYfy+mPoF50rLhOp7y7wFrAkhVl+5d3ef4A", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Ad Table Bucket Number" = _t, #"Title For Conversion %" = _t, #"Title For Cost Per Signed" = _t, #"Title CPS Roundup" = _t, #"Title CPS Talcum" = _t, #"Title CPS Hernia Mesh" = _t, #"Title CPS Zantac" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Ad Table Bucket Number", Int64.Type}})
in
    #"Changed Type"

Slicer Ads Buckets Title

Slicer Ads Bucket Title = 
SWITCH (
    [Selected Ad Bucket],
    1, SELECTEDVALUE ( SlicerAdsBucketsTitles[Title For Conversion %] ),
    2, SWITCH (
        SELECTEDVALUE ( LeadVendorCampaigns[Lead Type] ),
        "Roundup", SELECTEDVALUE ( SlicerAdsBucketsTitles[Title CPS Roundup] ),
        "Talcum", SELECTEDVALUE ( SlicerAdsBucketsTitles[Title CPS Talcum] ),
        "Hernia Mesh", SELECTEDVALUE ( SlicerAdsBucketsTitles[Title CPS Hernia Mesh] ),
        "Zantac", SELECTEDVALUE ( SlicerAdsBucketsTitles[Title CPS Zantac] ),
        SELECTEDVALUE ( SlicerAdsBucketsTitles[Title For Cost Per Signed] )
    )
)

To Convert DAX

To Convert = 
VAR _maxDate =
    MAX ( 'CalendarAnalysis'[Date] )
VAR _datesTable =
    DATESBETWEEN ( 'CalendarAnalysis'[Date], _maxDate - 60 + 1, _maxDate )
RETURN
    SUMX (
        VALUES ( LeadVendorCampaigns[Lead Type] ),
        SWITCH (
            LeadVendorCampaigns[Lead Type],
            "Roundup", SUMX (
                ADDCOLUMNS (
                    VALUES ( Leads[lead_form_round_up_cancer_diagnosed] ),
                    "Conv", CALCULATE ( [Converted Leads %], _datesTable )
                ),
                ROUND ( [Conv] * [Status Callable Qualified %] * [Leads Count], 0 )
            ),
            "Talcum", SUMX (
                ADDCOLUMNS (
                    VALUES ( Leads[Lead Form Talcum Powder Cancer Type] ),
                    "Conv", CALCULATE ( [Converted Leads %], _datesTable )
                ),
                ROUND ( [Conv] * [Status Callable Qualified %] * [Leads Count], 0 )
            ),
            "Hernia Mesh", SUMX (
                ADDCOLUMNS (
                    VALUES ( Leads[Lead Form Hernia Mesh Revision Surgery] ),
                    "Conv", CALCULATE ( [Converted Leads %], _datesTable )
                ),
                ROUND ( [Conv] * [Status Callable Qualified %] * [Leads Count], 0 )
            ),
            "Zantac", SUMX (
                ADDCOLUMNS (
                    VALUES ( Leads[Lead Form Zantac Cancer Type] ),
                    "Conv", CALCULATE ( [Converted Leads %], _datesTable )
                ),
                ROUND ( [Conv] * [Status Callable Qualified %] * [Leads Count], 0 )
            ),
            0
        )
    )

intakedesk / PowerBI-General

Zantac PIDS: Change CPS Ranges to $500 and $800 #650