Delta calculation with dynamic update of selection of filters and dimensions .

[Anonymous]

I have create a matrix visualization where it include a heirarchy of multiple dimension like country , technology, etc. Additonally i have fiscal year as slicer  .

For column called Type , I have two values; Budget and actual. 

For value i have SALES

Now I want to derive the delta at each level of drill down for this matrix visual to work independent of filter and dimensions used in matrix. More like a table calculation but instead of total i want a delta.

I searched the community but cant find where it calculates for the selection in matrix dynamically 

[v-yingjl]

Hi @Anonymous ,

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!

Best Regards,
Yingjie Li

[amitchandak]

@Anonymous , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Check if this can help

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Appreciate your Kudos.

[Mariusz]

Hi @Anonymous 

You can remove the total and create a Measures for

1. Actual
2. Budget
3. Delta - using the above two measures

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

Thanks @Mariusz for the guidance. But I dont want to create seperate measure for actual and budget as as my type can have other values like Prevoius year , prevous month as well. which means i would have create a measure for all of them and then delta for each combination. This would create 

I need a calculation called delta that it create a diff in value based on aggregration happening in matrix dynamically which include all filter in matrix for both actual and budget

delta = [sum(KPI) in Column1- sum(KPI) in Column2] with all filters inscope of  the pivot table 

[v-yingjl]

Hi @Anonymous ,

Based on your description, I think create the simple measure as your mentioned formula can achieve this issue:

My sample data table:

Measure = SUM('Table'[Actual]) - SUM('Table'[Budget])

Results in the matrix visual with slicers:

Best Regards,
Yingjie Li

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