Forum Discussion

Arun_BI's avatar
Arun_BI
Icon for Helper I rankHelper I
4 years ago
Solved

Data slicing issue in Power BI

Hi All,   I am new to PowerBI. Can someone please help me to understand what I did wrong?   I have two SharePoint lists, one list has planned hours of staff and another one has the actual time of...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Arun_BI ,

     

    Create a measure to replace [Claim Hours] in the visual.

    Measure = CALCULATE(SUM('Time log'[Hours Claim]),FILTER('Time log','Time log'[Project Name] in VALUES(FTE[Project name])))

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Arun_BI ,

 

Create a measure to replace [Claim Hours] in the visual.

Measure = CALCULATE(SUM('Time log'[Hours Claim]),FILTER('Time log','Time log'[Project Name] in VALUES(FTE[Project name])))

 

Best Regards,

Jay

Arun_BI's avatar
Arun_BI
Icon for Helper I rankHelper I
4 years ago

Anonymous Thanks Mate, I am able to achieve my desired results by creating a measure. Thank you so much for the help and thanks to all the community members