Need help in DAX formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1458087%22%20slang%3D%22en-US%22%3ENeed%20help%20in%20DAX%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1458087%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20divide%20columnA%20of%20Pivot%2C%20and%20ColumnC%20of%20pivot%20table%20using%20DAX%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnable%20to%20do%20so.%20Can%20anyone%20please%20help%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1458087%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1462000%22%20slang%3D%22en-US%22%3ERE%3A%20Need%20help%20in%20DAX%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1462000%22%20slang%3D%22en-US%22%3EYou%20could%20do%20it%20with%20a%20calculated%20field%20within%20the%20pivot%20table%20(PIVOT%20TABLE%20TOOLS%20%26gt%3B%20ANALYZE%20%2F%20FIELDS%2C%20ITEMS%20%26amp%3B%20SETS%20%26gt%3B%20CALCULATED%20FIELD)%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi

 

I am trying to divide columnA of Pivot, and ColumnC of pivot table using DAX formula.

 

Unable to do so. Can anyone please help me.

 

Thank you

 

1 Reply
Highlighted
You could do it with a calculated field within the pivot table (PIVOT TABLE TOOLS > ANALYZE / FIELDS, ITEMS & SETS > CALCULATED FIELD)