% Percentage

[chethan]

Hey, I Need Help,

I Have an Excel File (Link) where report created I need to migrate the report to power bi 

My Challenges are total  

Whenever if I filter it's not showing correct numbers 

am attaching the Pbix file Link

Please help 

Regards,

Chethan K

[chethan]

[v-huizhn-msft]

Hi @chethan,

You add two measure in the table visual, so it only display one row shown in picture1. Because there is no row context in the table visual, the measure returns the total value for the resource table. Just like, you add a measure in a card visual, it only display total one value for the table. You should create a calculated column as you did(the column name is Category_column), and it returns correct result as picture2 shown.

picture1picture2
For your picture posted, how did you get it. What's the error and what expected result you want to get? Please share more details for further analysis.

Best Regards,

Angelia

[chethan]

@v-huizhn-msftI have created the measure Below is the DAX  

Attrition% = 
VAR Actual_Attr_Count =
    SUM ( 'Raw Data'[Actual ATTR Count] )
VAR OpeningHeadCount_ClosingHeadCount =
    AVERAGEX ( 'Raw Data', 'Raw Data'[Opening HC] + 'Raw Data'[Closing HC] )
        / 2
VAR Attrition__Per__ =
    DIVIDE ( Actual_Attr_Count, OpeningHeadCount_ClosingHeadCount, 0 )
RETURN
    IF ( ISBLANK ( Attrition__Per__ ), 0, Attrition__Per__ )

[v-huizhn-msft]

Hi @chethan,

You have resolved your issue?  If you have, please mark right reply as answer, so more people will get workaround easily and clearly.

Best Regards,
Angelia