Measure doesn't allow right report slicing

[Anonymous]

Hi Community,

I have two dim tables- Datedim & Empdim. Empdim is related to two other tables. There is a measure 'Hrs Productivity' in empdim that I have on a matrix layout. This measure is not slicing the year/months properly: for example if 2021 is selected, the measure makes the data to be displayed for prior months/year.

Here is my Pbi file: https://1drv.ms/u/s!Ag919_pO_UKrgReCwuTjqZXdT9fW?e=HGZjvg

Many thanks in advance,

[aj1973]

Hi @Anonymous 

Trying to understand your issue, is it why the cells are empty when you select 2021? if so what are you expecting to see?

[Anonymous]

@aj1973  No this is not the case. The issue happens when I bring in the measure 'Hrs Productivity' from Empdim table on to the matrix. Please check my PBI file in the post.

If I create 'Hrs Productivity' in any of the other 2 tables (Query1 & Hrs_worked, relating to Empdim) then it resolves the issue of incorrect slicing but I get incomplete data.

[aj1973]

I did, that's why I am asking and you are not telling what you want to see!!

Ok Play with your 'a'  variable maybe I am close to understand what you are looking for

[Anonymous]

@aj1973 thanks for replying. What I expect is: when 2021 & all the months are selected, then data for only 2021 Jan,feb & march should be displayed in the matrix The issue is that its displaying 2020 data as well. It was displaying data beyond March 2021, that I handled by including the following 'If' condition in the measure:

[aj1973 · Accepted solution]

Ok 2 things to change

Use Date hierarchie in your Matrix and Also date hierachie in your Slicer Year(don't Use column Year

Voila