Link to home
Start Free TrialLog in
Avatar of Sonia Bowditch
Sonia BowditchFlag for Guernsey

asked on

Issues with DAX Calculated Columns

Hello Experts,

I have created a Power Pivot table which I create a calculated column to work out a percentage.  The DAX function I am using is DIVIDE:

=DIVIDE([field1],[field2],0)

The result is correct in Power Pivot but when I go to create a Pivot Table on the table using the calculated column, the result is incorrect.

For example the result of the query in Power Pivot is 99.20% but in the Pivot Table the result is showing as 975.16%.

What could I be doing wrong?

Any help you could give me would be greatly appreciated.

Thanks
InfoSec36
Avatar of Shums Faruk
Shums Faruk
Flag of India image
Uploading sample file would be great help.

Please refer to DIVIDE() and Conquer - PowerPivot Pro
If this helps.
Avatar of Sonia Bowditch
Sonia Bowditch
Flag of Guernsey image

ASKER

Hello,

Thank you for getting back to me so quickly.  It was the DIVIDE() and Conquer webpage where I got the idea to use DIVIDE in the Power Query window as a calculated column to solve this issue but no such luck.

Attached is an example file as requested.

Thanks
InfoSec36
Test-File.xlsx
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image
Hi Infosec,

Please help me with more details or if possible send Excel or how you are using it?
SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sonia Bowditch
Sonia Bowditch
Flag of Guernsey image

ASKER

Thank you both.

I will create measure instead of a calculated column.

Thanks
InfoSec36