Forum Discussion

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

miracle2023 , You can use what if parameter in a measure. On the selected row, you can not apply it. What you have selected will get filtered on other visual, there you can use isfiltered in measure and then use what if parameter

 

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

  • miracle2023's avatar
    miracle2023
    Icon for Helper I rankHelper I
    2 years ago

    Hi,

    Thank you for your answer.

    Im trying to build forecast based on due cases and people's allocation towards tasks and their handling times. Allocation and handling times are two "what-if parameters" that directly impact cases delivery column. Another what if parameters are supposed to use for selecting rows in which we can apply allocation and handling times. For selecting rows, I built two index columns from 1 to 12, (current month is blank and next is 1 etc) and made a single relationship between them. 

    P.S seems I got my error and everyting works so far. 

    I made inactive relationships between index columns and parameters and built following queries for cases delivery. Also cleander up running total measure. 

    HighRisk_Delivery =
VAR measure1 =
    CALCULATE (
        ( 115.5 * [nrow_Allocation_OEDD(Used)] ) / [nrow_AHT_OEDD(Used)],
        USERELATIONSHIP ( dimDate[Indexcolumn2], 'Nrow Allocation'[Nrow Allocation] ),
        USERELATIONSHIP ( dimDate[Indexcolumn], 'Nrow Handling Times'[Parameter] )
    )
VAR measure2 =
    CALCULATE ( ( 115.5 * [Allocation OEDD(Used)] ) / [6M_AVGAHT_OEDD(Used)] )
RETURN
    IF (
        SELECTEDVALUE ( 'Nrow Allocation'[Nrow Allocation] )
            || SELECTEDVALUE ( 'Nrow Handling Times'[Parameter] )
            || SELECTEDVALUE ( 'Nrow Handling Times'[Parameter] )
            || SELECTEDVALUE ( 'Allocation OEDD'[OEDD Parameter] ),
        measure1,
        measure2
    )

Mediumrisk_Delivery =
VAR measure1 =
    CALCULATE (
        ( 115.5 * [nrow_Allocation_ODD(Used)] ) / [nrow_AHT_ODD(Used)],
        USERELATIONSHIP ( dimDate[Indexcolumn2], 'Nrow Allocation'[Nrow Allocation] ),
        USERELATIONSHIP ( dimDate[Indexcolumn], 'Nrow Handling Times'[Parameter] )
    )
VAR measure2 =
    CALCULATE ( ( 115.5 * [Allocation ODD (Used)] ) / [6M_AVGAHT_ODD(Used)] )
RETURN
    IF (
        SELECTEDVALUE ( 'Nrow Allocation'[Nrow Allocation] )
            || SELECTEDVALUE ( 'Nrow Handling Times'[Parameter] )
            || SELECTEDVALUE ( 'Nrow Handling Times'[Parameter] )
            || SELECTEDVALUE ( 'Allocation OEDD'[OEDD Parameter] ),
        measure1,
        measure2
    )

Delivery_of_cases = SWITCH(SELECTEDVALUE(dimRisk[RiskCustom]),
"Medium/Low", [Mediumrisk_Delivery],
"High", [HighRisk_Delivery],
[SumDeliveries])