Forum Discussion

sparker95's avatar
sparker95
Frequent Visitor
3 years ago
Solved

Filtering using slicer

 I have a table with columns for 'Status' which has 5 options {1. Fee Forecast, 2. Confirmed, 3. Likely, 4. Planning, 5. Spec}, another that is 'Date' that gives me {Q1, Q2, Q3, Q4} and finally a 'Fe...
  • Sahir_Maharaj's avatar
    3 years ago

    Hello sparker95,

     

    Can you please try:

     

    1. Create Individual Slicer Measures

    Fee Forecast % = [1. Fee Forecast %. Value]
    Confirmed % = [2. Confirmed %. Value]
    Likely % = [3. Likely %. Value]
    Planning % = [4. Planning %. Value]
    Spec % = [5. Spec %. Value]

    2. Create Individual Adjustment Measures

    Fee Forecast Adjusted =
    SUM(Table2[Fee]) *
    (1 + [Fee Forecast %] / 100)
    
    Confirmed Adjusted =
    SUMX(
        FILTER(Table2, Table2[Status] = "Confirmed"),
        Table2[Fee] * (1 + [Confirmed %] / 100)
    )
    
    Likely Adjusted =
    SUMX(
        FILTER(Table2, Table2[Status] = "Likely"),
        Table2[Fee] * (1 + [Likely %] / 100)
    )
    
    Planning Adjusted =
    SUMX(
        FILTER(Table2, Table2[Status] = "Planning"),
        Table2[Fee] * (1 + [Planning %] / 100)
    )
    
    Spec Adjusted =
    SUMX(
        FILTER(Table2, Table2[Status] = "Spec"),
        Table2[Fee] * (1 + [Spec %] / 100)
    )

    3. Create a Master Measure to Combine Adjusted Values

    Adjusted Fee Total =
    [Fee Forecast Adjusted] + [Confirmed Adjusted] + [Likely Adjusted] +
    [Planning Adjusted] + [Spec Adjusted]

    Should you require further assistance, please do not hesitate to reach out to me.