Results 1 to 2 of 2

Thread: Calculated measure in Pivot Table

  1. #1
    Neophyte fher97's Avatar
    Join Date
    Jun 2021
    Posts
    1
    Articles
    0
    Excel Version
    2019

    Calculated measure in Pivot Table



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi!

    Ive been trying to get a measure in my pivot table to get the % of reject orders of a partner / Total order order of partner, and that it can change if I use a slicer to change it by day, month, etc.

    This is an example of the data table which I use:

    Click image for larger version. 

Name:	1623629878531.png 
Views:	12 
Size:	66.5 KB 
ID:	10532

    And this is the pivot table which I have created:

    Click image for larger version. 

Name:	1623629917661.png 
Views:	11 
Size:	10.3 KB 
ID:	10533

    I would like to calculate the Percentage of Rejected message type of the Partners (fail rate owner Partner) / Total orders of the Partner(this would be the total of rejected messages which from all type of fail rate owner), and that the measure could change if a filter the data by date or which whatever I filter it.

    I can do it with countifs but i need to get this percentage in the Pivot table.

    For example: in high demand por partner 1, it only has 1 count, but the total orders for this Partner are 7, the percentage would be: 1/7 = 14%


    I attached the example file and I would be very grateful if anyone could help me.

    thanks!
    Attached Files Attached Files

  2. #2
    Seeker RET's Avatar
    Join Date
    Nov 2020
    Location
    Spain
    Posts
    18
    Articles
    0
    Excel Version
    2019
    For that you should create a PowerPivot data model and then that measure with Dax

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •