Forum Discussion

AndreaLorenzo's avatar
AndreaLorenzo
Frequent Visitor
2 years ago

Using TREATAS for different granularity levels

Hi, I'm struggling with a common problem (two tables with different granularity) and I hope someone could help me. I need to comparte the actual sales pending invoice amount with the budgeted one, ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi AndreaLorenzo ,

 

Please try this:

Sales_vs_Goals = 
CALCULATE(
    SUM(Sales[Pending_Sales_Amount]),
    TREATAS(
        SUMMARIZE(ALLSELECTED(Goals), Goals[Year], Goals[Id_Area], "Pending_Goal", SUM(Goals[Pending_Goal])),
        Sales[Year],
        Sales[Area_Id]
    )
)

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.