calculated measure

  1. J

    calculated measure vs formula?

    Hi all, I am trying to figure out how to use a calculated measure as part of an equation for another calculated measure... Basically I'm trying to create a calculated measure to calculate the Coefficient of Dispersion (COD). Excel 2016 has this formula built in, but I'm trying to create it in my...
    • jbaich
    • Thread
    • calculated calculated measure data model formula median
    • Replies: 5
    • Forum: Power Tools
  2. A

    Calculating average over calculated measure

    Hi I have a measure in Powerpivot that calculates productivity for 3 different work groups over various weeks (both applied by slicers). The measure includes multiple calculations, a number of filters coded into the measure, as well as the work group and date filters applied by slicers. I...
    • adva
    • Thread
    • average calculated measure
    • Replies: 5
    • Forum: Power Tools
  3. R

    How can I filter a PowerPivot table based on a calculated measure?

    Hi, I'm trying to build a system that can localize large deviations in survey data. Right now I'm using PowerPivot to calculate all the "weekly answer levels" for the survey questions (as a percentage). Also I have created a four-week moving average which I compare the to the weekly answer...
    • res.marcus
    • Thread
    • boolean calculated measure filter by value powerpivot
    • Replies: 11
    • Forum: Power Tools

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top