Remove effect of slicer from measure and putting custom filter in dax measure.Problem in star schema

[Anonymous]

I have two slicers one is date slicer and the other one is name slicer . i have three dimesional table and one fact table of type Accumulating Snapshot Fact Table. Now the thing is i want to select a month from slicer and based on that month i want to get all the name and data which were present in that month.  This is my table in which all the data is available.
  

Now what i am trying is to convert this data into star schema.  I have made three dimension tables out of it i.e.

1. Rating dimension
2. Date Dimension
3. Employee Dimension
   and one fact table in which all the keys of dimension tables is present and i am making measures in this table using dax.
   Rating DimesionDate DimensionEmployee DimensionFact Table
   Now the thing is the date key present in both fact table and date dimension is based on Rc.c date as i want to get the names of employee from this dates however i also want to filter my fact table based on Date type and date month present in fact table after removing the slicer effect from these two coloumns i.e. if i select march than the names should be shown according to march while when name and month march both are selected then based on date type  the count of rows with respect to the employee key and month should be shown .
    I think my star schema mapping is not right but i can find a way to make it right. I have tried to use allexcept function, all function and remover filters function in my dax but nothing seems to be working as required.
   var choseMonths = values(Date dimension [month number])
   calculate(countrows(facttable), filter(all(facttable), facttable[date type] = "Rcm Date" && month(Date) in chosenMonths)
   
   Any help would be appriciated. 

[Anonymous]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept the helpful reply as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[Anonymous · Accepted solution]

Hi @Anonymous 

Do you want to remove the filter by date and name in measure?

You can try to use all function in slicer tables.

Could you show me a screenshot of your issue and the result you want?

Or you can provide me with your pbix file by your Onedrive for business.

This may make it easier for me to understand you requirement.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.