Forum Discussion

vojtechsima's avatar
vojtechsima
Icon for Super User rankSuper User
4 years ago
Solved

Matrix - Total to All when filtered

Hi, guys, I am quite struggling with this one: I need this table: BU Something Total by BU Total by Item Total by selected BU Elle 5500 7068927 6500 8608966 Louis 1000 1540039 ...
Need Help
  • vojtechsima's avatar
    vojtechsima
    4 years ago

    Hi, amitchandak 
    I am a bit embarrassed that I didn'T figure this out, however, I managed to fix it by referencing the previous measure and adding the ALL filter.

    var __calc = CALCULATE('sample'[AllexceptBU], ALL('sample'[BU]))
return __calc

    However, I appreciate your time and effort. Thank you

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

vojtechsima , try if one of the two can help

 

var __SelectedBUs = VALUES('sample'[BU])

var __calc = CALCULATE(SUM('sample'[Something]),Keepfilters('sample'[BU] IN __SelectedBUs)

or


var __SelectedBUs = VALUES('sample'[BU])

var __calc = CALCULATE(SUM('sample'[Something]),'sample'[BU] IN __SelectedBUs)

vojtechsima's avatar
vojtechsima
Icon for Super User rankSuper User
4 years ago

Hi, amitchandak 
Unfortunately, this gives me something that I already did in previous tries, I am still not getting the same result for all rows in my matrix.
I need to have the sum of mentioned BUs in all rows (the same value) and I also need to filter out the "Item" slicer.