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])

harshagraj's avatar
harshagraj
Post Partisan
6 years ago

Sorry for the trouble. I have Project Number,Tool Number,Loop Type as columns.
In Loop Type column i have values as (Finished & Planned). Each tool number will have one loop type. So i need Averge loop type per project.
Eg.

PRJ-1921-18Finished Loop
PRJ-1921-19Planned Loop

So this has 1 Finished and 1 Planeed. So i need to display Average loop as 1.

  • harshagraj's avatar
    harshagraj
    Post Partisan
    6 years ago

    Hi amitchandak thanks for the solution. But it is need working please correct the highligted error
     countx(filter(Table, [project] earlier([project]) && [loop type] = earlier([loop type])),[loop type]).

    • amitchandak's avatar
      amitchandak
      Super User
      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])