Forum Discussion

user900's avatar
user900
Helper II
3 years ago
Solved

Chart Help

I have a data file that shows User Name, Status and Department. Using the stacked bar chart, I'm showing the Department on the Y-Axis, count of Users on the X-Axis and Status as legend.  I need to al...
Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    HI user900 ,

     

    Delete this relationship and everything should work has you need.

user900's avatar
user900
Helper II
3 years ago

I created the new table and applied the suggested measure. When I pull the fields into the chart, the counts in each individual department is correct, but Enterprise is blank.  I need it to total all the Users in all Departments.   Here's what it looks like.

 

 

MFelix's avatar
MFelix
Super User
3 years ago

Hi user900 ,

 

Can you share the metric formula please.

 

  • user900's avatar
    user900
    Helper II
    3 years ago
    Total values =
    SWITCH(
    SELECTEDVALUE('LOB order'[Line of Business]),
    "Enterprise-Wide", COUNTROWS('Colleague Data'),
    COUNTROWS(
    FILTER('Colleague Data', 'Colleague Data'[Line of Business] in VALUES('LOB order'[Line of Business])
    )
    )
    )
    • MFelix's avatar
      MFelix
      Super User
      3 years ago

      Hi user900 ,

       

      Base on the syntax everything should be correct, please verify if there is an active relationship between both tables, the table that you created with the enterprise, needs to bve a disconnected table from the other ones on the model.

  • user900's avatar
    user900
    Helper II
    3 years ago

     

    • MFelix's avatar
      MFelix
      Super User
      3 years ago

      HI user900 ,

       

      Delete this relationship and everything should work has you need.

      • user900's avatar
        user900
        Helper II
        3 years ago

        Thank you so much!