Forum Discussion

harshagraj's avatar
harshagraj
Post Partisan
6 years ago
Solved

Average loop type per project

HI all, I need average loop type for the below table. loop_type column is a dimension. Thanks in advance. Need to display this in a card. I have a project slicer to filter. Project ToolNo ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    harshagraj 

    Loop count = countx(filter(Table, [project] =earlier([project]) && [loop type] = earlier([loop type])),[loop type])
    Avg Loop =AverageX(filter(Table, [project] =earlier([project])),[Loop count])

amitchandak's avatar
amitchandak
Super User
6 years ago

harshagraj , not very clear

averagex(values(dim[Project]),max(Table[Count of loop_type]))

or
averagex(summarize(dim[Project],"_1",max(Table[Count of loop_type])),[_1])

harshagraj's avatar
harshagraj
Post Partisan
6 years ago

Hi amitchandak thanks for the reply. Actually i dont have [Count of loop_type] column i just changed that in value shelf from a table and dragged.