Calculating a Level of Detail while also using a Parameter

[cbschley]

Hello,

I'm familar with creating what Tableau calls a "level of detail" calculation. In PowerBI we use CALCULATE along with an ALLEXCEPT to generate the level of detail we want. However, I am running into an issue when trying to calculate it at different levels when I introduce a parameter. It appears that it doesn't know how to calculate this, and therefore it returns a non-aggregated number.

Here is how I'm building my measure, any help would be appreciated:

CALCULATE(
sum(DEMAND[PACINGOUTLOOK])

,ALLEXCEPT(Parameter_ForecastDate,Parameter_ForecastDate[Parameter_ForecastDate])

)


I would expect to see something like this, where I get the 170M number in the LOD column. This one was built without using a parameter:

But instead, I get this when using a parameter (non-aggregated value):

[Syndicate_Admin]

hi

[Fowmy]

@cbschley 

In your formula, what you basically do is to remove the filter from all the coumns in the table Parameter_ForecastDate  and keep only the filter coming from [Parameter_ForecastDate] , so you should include the column [Parameter_ForecastDate] in the table visaul as well.

[cbschley]

@Fowmy , I think I understand your statement. I am actually using the [Parameter_ForecastDate]  column in my table visual. As you can see below, I have four different options, and the visual in my original post is using the "Forecast Month". It would appear I am doing what you suggested, but it does not work unfortunately.