Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Average based on distinct count and summing up

Hi everyone, I have a input table with ID . i need a measure which calculates average of due days foe each Id. In this example my output should be 25. It should sum up the due dates for ea...
  • DimaMD's avatar
    DimaMD
    4 years ago

    Hi Anonymous what is your desired result?


MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
4 years ago

Create a dimension table containing all the unique IDs.
Join it to this table shown

remove the ID shown and replace with the ID from the dim table. 
then write a measure

AVERAGEX(NewDimTable,calculate(sum(originalTable[due days])))

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    MattAllington like i said i need this for a card visual so will this method work, is there a way we could achieve the same functionality with a measure?