Share of Base calculation

[logan_logan]

Hi,

I am using this to get the base volume for the share.

AllVolume = 

VAR Last_Date = LASTDATE(CALENDAR[Period])

RETURN CALCULATE ( SUM ( TABLE[DOLLARS] ),FILTER(All(CALENDAR[Period]),CALENDAR[Period]=Last_Date),   ALL(TABLE[CHANNEL_TYPE] ))        

I am getting result in CARD but if i put it in Matrix, I see the breakdown of Channel_type

Channel_Type	AllVolume
A	40
B	50
Total	90

However I need the result like this:

Channel_Type	AllVolume
A	90
B	90
Total	90

[logan_logan]

I used AllEXCEPT() and put all the filters I used for that graph and working. 

[logan_logan]

Yes, you are right. I have other 3 columns in the filter to consider. 

[tamerj1]

@logan_logan 

Then have them all inside ALL function

[tamerj1]

Hi @logan_logan 

this should work unless there is/are other column(s) in the filter context that you did not specify in your example or if the relationship between Calendar and Table is bidirectional.