Forum Discussion

ashmitp869's avatar
ashmitp869
Responsive Resident
1 year ago
Solved

dax expression help needed

Hi All, Help me with a measure- Current dax Forecast to complete = VAR FC_Terminal = SUMX( FILTER( CostItem, CostItem[Is_terminal] = TRUE() ), ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi ashmitp869 ,

     

    Please try below DAX measure:

    Forecast_to_complete_test_1 =

    VAR ForecastMethod_CurrentRow =

        SELECTEDVALUE(CurrentProjectForecastDetail[Forecast_Method], "None")

    VAR RowValue =

        IF(

            ForecastMethod_CurrentRow = "None",

            0,

            [Remaining Qty] * [CE Rate]

        )
    RETURN

    IF(

        ISINSCOPE(CostItem[Cost_item_id]),

        RowValue,

        SUMX(

            FILTER(

                CostItem,

                CostItem[Is_terminal] = TRUE()

                    && RELATED(CurrentProjectForecastDetail[Forecast_Method]) <> "None"

            ),

            [Remaining Qty] * [CE Rate]

        )

    )

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

    Regards,

    B Manikanteswara Reddy

Ashish_Mathur's avatar
Ashish_Mathur
Super User
1 year ago

Hi,

Share the download link of the PBI file.  Explain the problem in simple English.  Show the expected result clearly.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    1 year ago

    Hi,

    Used these measures

    Measure 2 = [Remaining Qty] * [CE Rate]
    Measure 4 = MAX(CurrentProjectForecastDetail[Forecast_method])
    Measure 3 = SUMX(FILTER(VALUES(CostItem[CBS Level 4]),[Measure 4]<>"None"),[Measure 2])

    Hope this helps.