Forum Discussion

Schwabinsky's avatar
Schwabinsky
New Member
1 year ago

Changing team assignment solution

Hello everyone, I have the following problem when customizing my report. We already have a report that tracks the workload of our project teams. Simplified, the report consists of a project table (p...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Schwabinsky ,

 

You can create a date slicer, then create a measure [Flag] and place [Flag=1] on the visual object filter.

date slicer = CALENDAR(DATE(2000,1,1),DATE(2100,12,31)) 
Flag = 
 var _min_slicer=MINX(ALLSELECTED('date slicer'),[Date])
 var _max_slicer=MAXX(ALLSELECTED('date slicer'),[Date])
 RETURN IF(MAX(dim_Employee[StartDate])=_min_slicer && MAX('dim_Employee'[EndDate]) =_max_slicer,1,0)

 

 


According to your data, dim_Employee and fact_Projecthours are many-to-many relationships, TeamA corresponds to 1001 and then 1001 corresponds to 101898 and 101900 respectively, can you explain why 1001 only corresponds to 101898 in the output? If I missed something please add it in a follow up reply.

 

Instead of directly associating many-to-many tables, we usually recommend that you consider a star schema.

Understand star schema and the importance for Power BI - Power BI | Microsoft Learn

Many-to-many relationship guidance - Power BI | Microsoft Learn

 

Best Regards,

Neeko Tang

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