Dax - filter should not associate particular measure

[Anonymous]

Hi,

I have the source data as following.

In powerbi i create  the following report using table chart

I'm looking for a way so that clicking on the 'date' in the filter, will not affect or change the 'Required' column and will only affect the 'Received' column.

Note:  Required and Received column is created using dax Query(measure)

Thanks in Advance,

Priviya .P

[Anonymous]

Hi,

Provided the Pbix file following url:

https://avacorp1-my.sharepoint.com/:u:/g/personal/yuvaraj_g_avasoft_com/EW4UHUZ5miJFhaeS8JVbXfUBGb0z...

PowerBI Report:

If i click 24-Jun-2019, it shows like following image

But i expect as following report, if i click 24-Jun-2019 date filter

[Cmcmahan]

If you want the received column to be unaffected by filters, you'll have to set it up as a measure that explicity removes filters:

Received1 = CALCULATE( SUM(Sheet1[Received]), ALLEXCEPT(Sheet1,Sheet1[ProjectName]))

[Anonymous]

Hi Cmcmahan,

Thanks for your update, but With in a table Chart this measure is not working.

Provided the sample pbix file:

https://avacorp1-my.sharepoint.com/:u:/g/personal/yuvaraj_g_avasoft_com/EW4UHUZ5miJFhaeS8JVbXfUBGb0z...

Thanks in Advance,

Priviya .P

[Cmcmahan]

It's not working because you're using values from [Received] to calculate your measure [Required1].  My apologies on getting which field needed to be frozen wrong, but at least proofread the measures you get from here. 

Change the measure to 

Required1 = CALCULATE( SUM(Sheet1[Required]), ALLEXCEPT(Sheet1,Sheet1[ProjectName]))

[Anonymous]

Hi Cmcmahan ,

Thank you so much, 

we want one more scenario on this. if i click the date 24-Jun-2019, then dimension Column(ProjectName) also should not changed.Expect as following.

Note: Receive measure should change when we click the date filter

Thanks in Advance

[Cmcmahan]

So this is a reason to have a separate date dimension table.  Because the filter is based on values in the Sheet1 table, the data gets filtered out before the table is even aware of it. 

f you created a seperate date dimension table, you could filter on that, and check the "Show Items with No Data" option for ProjectName in the values bucket.