Forum Discussion

ahmetturetmis's avatar
ahmetturetmis
Frequent Visitor
6 years ago
Solved

DAX measure Suggestion

Hello All,   I would like to ask a measure formula because I couldn't write properly. I miss some little details but I can't see where.    You can see the table below. I add some Letters on top t...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi ahmetturetmis,

    You can use following calculate table formula to create a new table that summary raw table value, it should dynamically change based on the raw 'calculation table':

    summary =
GROUPBY (
    SUMMARIZE (
        T2,
        [FROM CBS],
        [FOCUS CBS],
        [MH],
        "Rate", [Final Weightage] * [MH]
    ),
    [FOCUS CBS],
    "Total", SUMX ( CURRENTGROUP (), [Rate] )
)

    Regards,

    Xiaoxin Sheng

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

ahmetturetmis , can you share actual formula

Can you share sample data and sample output in table format?