Forum Discussion

chethan's avatar
chethan
Icon for Resolver III rankResolver III
8 years ago

% Percentage

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 number...
Need Help
chethan's avatar
chethan
Icon for Resolver III rankResolver III
8 years ago

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's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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