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.

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.