Forum Discussion

gottapu's avatar
gottapu
Frequent Visitor
5 years ago
Solved

Employee FTE calculation

Hi,   I have data similar to tables below. Fact table that I se connects to number of other dimension tables and so number of rows per each assignment id are much larger but I have simplified it to...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago

    gottapu how about changing the code like this?

    Employee FTE:=IF(COUNTROWS('Fact'),SUMX(ALL(Assignment[Asgn ID]),CALCULATE(MAX('Fact'[Assignment FTE]),ALL(RepGroup[Rep Group Name]),ALL('Fact'[Assignment FTE]))))
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

gottapu how about adjust the code like this

 

gottapu's avatar
gottapu
Frequent Visitor
5 years ago

Thank you so much wdx223_Daniel . I have been working on this calc for last few days and breaking my head. I am relatively new to Power BI DAX code. I have gone through Plural sight DAX videos and other DAX documentation available on web but still struggled to get to correct number. You have made my day. Thank you so much for going extra mile to help.

 

Thanks,

-Raj