Forum Discussion

MissBI_21's avatar
MissBI_21
Helper II
5 years ago
Solved

Measure does not sum in table

Hi,   I was wondering if anyone could help.   I have a measure (UK Days Available) which uses data from two tables:   When I have this measure in a table by name of employee, it does not ...
Need Help
parry2k's avatar
parry2k
Super User
5 years ago

MissBI_21 create another measure  and use it for visualization

 

New Measure = SUMX ( VALUES ( YourTable[Employee] ), [Existing UK Days Available Measure] )

 

✨ Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

 

  • MissBI_21's avatar
    MissBI_21
    Helper II
    5 years ago

    This worked! Thank you so much! 

    • MissBI_21's avatar
      MissBI_21
      Helper II
      5 years ago

      Out of the employees, if I wanted a particular employee to show a certain amount and the others to be calculated by the formula, do you know

      how would I do that?