sql - Drill through issue in power BI

Question

I have a Landing page where I was showing total meals spend by employee on the clustered bar chart.

From this graph, I have selected one of the employees and drill through to the detail page (Employee Page) where I was showing This Employee vs Average Employee data on the Clustered Column Chart (on Axis I have taken KPI Column).

This Employee – we are calculating the count of meals with flagged KPIs (KPIhit=1) whereas Avg Employee measure we are dividing the count of meals where KPI Hit=1 with the total number of employees.

Let's say emp name Mahesh whose having 3 transactions which are perfectly displayed on the graph whereas avg empployee, I have 21 KPIs in Database but when comparing with This Employee I can see only few of them on the graph.

I want to display all KPIs(21) for Average Employee on the graph.

This Employee Measure

def = CALCULATE ( DISTINCTCOUNT ( 'abc'[Meal_ID] ), 'abc'[kpi_hit] = 1 )

Avg Employee Measure =
DIVIDE (
    CALCULATE ( [This Employee], ALL ( 'abc'[Emp_Nm] ) ),
     ( [No. of Employees] )
)

No. of Employees =
CALCULATE (
    DISTINCTCOUNT ( 'abc'[Emp_Nm] ),
    'abc'[kri_hit] = 1,
    ALL ( 'abc'[Emp_Nm] )
)

I would request you to please help with this.

question from:https://stackoverflow.com/questions/65879849/drill-through-issue-in-power-bi

Answer 1

Waitting for answers