Forum Discussion

jabueg's avatar
jabueg
Helper I
1 year ago
Solved

Help Adding Calculate Conditions to Switch Function

 Need help adding correct calculations into my Switch function using two tables: 1) PPI (premium per phone interaction) table 2) PROD sales table Calculate "Total PPI" using this formula: Total ...
"CALCULATE"
"DAX " "DAX help" 'Need help'
"DAX SWITCH"
USERELATIONSHIP DAX Measures
  • Rupak_bi's avatar
    Rupak_bi
    1 year ago

    Hi jabueg ,

    The sample file you shared, have only 102 rows in PPI table and 48 rows on 15/5. as per these data, the calculation working fine. please share a revised sample file and the expected result based on the sample file to wokr on this further and validate.

     

     

     

     

Rupak_bi's avatar
Rupak_bi
Super User
1 year ago

Hi jabueg ,

The sample file you shared, have only 102 rows in PPI table and 48 rows on 15/5. as per these data, the calculation working fine. please share a revised sample file and the expected result based on the sample file to wokr on this further and validate.

 

 

 

 

  • jabueg's avatar
    jabueg
    Helper I
    1 year ago

    Sorry, here is the revised sample file! There should be 2,904 rows in the PPI table.

    PBI PPI Project 

    I need to see these results when each "Department" is selected from the middle top visual:

     



    TOTAL PREMIUM FOR "Field" Department (from Prod Sales table): $846,573. 08
    PPI Count FOR "Field" Department (from PPI table): 1,202
    Total Premium / PPI count = Total PPI
    Expected Total PPI result when "Field" is selected: $704.30

    Total Premium for "Call Center" Department (from Prod Sales table): $951,098.02
    PPI Count for "Call Center" Department (from PPI table): 1,702
    Total Premium/ PPI Count = Total PPI

    Expected Total PPI result when "Call Center" is selected: $558.81

    Also, need to add conditions to the Switch to calculate PPI when selecting from slicer:

    - Date + Department
    - Advisor + Date + Department

    Example 1: Date + Department 

    If selecting date 5/16 and "Call Center" department,  Total premium = $28,843.80; Count of PPI is 52 from PPI Table.

    Result = $554.68

     

    Example 2: Advisor + Date + Department

    When selecting JOHN SMITH and date 5/12/25 and "Field" Department = Total Premium = $16,464.60; Count of PPI = 21 from PPI Table. 
    Result = $784.02

    Thank you in advance!