Forum Discussion

Daveed1973's avatar
Daveed1973
Icon for Advocate II rankAdvocate II
6 years ago
Solved

Issue displaying average on a line chart and table

I have a Power BI desktop file which I use to display utilisation of products. When I filter to just an individual product the figures are correct. However I need to show the average for multiple pro...
Need Help
  • Daveed1973's avatar
    Daveed1973
    6 years ago

    AnthonyTilley  I was using the average because I was getting a total figure which was really high and therefore making the utilisation around 1%. I have managed to fix this issue by doing the following.

     

    Column UiU gives me the number of products in use.

    Column ContractQty gives me the number of products they are contracted to use.

    Measure CountOfProducts = DISTINCTCOUNT(Utilisation[ProductType]) - gives me the number of distinct product types in the current filter

    Column ColumnUtilisation = Utilisation[UiU]/Utilisation[ContractedQty] - gives me the sum of the utilisation for the product types

    Measure Utilisation = SUM(Utilisation[ColumnUtilisation])/[CountOfProducts] - sum of utilisation divided by the number of product types to give me the average figure I need.

     

     

     

Daveed1973's avatar
Daveed1973
Icon for Advocate II rankAdvocate II
6 years ago
amitchandak wrote:

Is it made like this ?

MeasureUtilisation = Sum(Utilisation[MeasureUiU])/Sum(Utilisation[MeasureContracted])

I cannot set it this way as I am trying to refer to measures and it just throws an error.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Try

MeasureUtilisation = divide(Sum(Utilisation[MeasureUiU]),Sum(Utilisation[MeasureContracted]))

Please let us know what error u are getting