Forum Discussion

ashmitp869's avatar
ashmitp869
Icon for Responsive Resident rankResponsive 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

ashmitp869's avatar
ashmitp869
Icon for Responsive Resident rankResponsive Resident
1 year ago

May be I am getting that in that line, but how to work it out in terminal total
The Terminal is 1.5.1 Project Managent Team with 1,951,120 it should be 1,316,029

 

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
1 year ago

Hi,

I am not sure how your semantic model looks like, but please try something like below whether it works.

 

expected result measure: =
SUMX (
    SUMMARIZE (
        fact_table,
        dim_table[column_in_matrix_01],
        dim_table[column_in_matrix_02]
    ),
    [your_fixed_measure]
)