Forum Discussion

chethan's avatar
chethan
Resolver 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 numbers 

 

am attaching the Pbix file Link

 

Please help 

 

 

Regards,

Chethan K

Need Help

4 Replies

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      8 years ago

      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's avatar
        chethan
        Resolver 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__ )