Forum Discussion

danandr87's avatar
danandr87
New Member
4 years ago
Solved

Need help with Measure (Average, Summarize)

Hi there,   i am quite new to Power Bi and need some helf for a specific measure i want to create.   This is my simplified data model:     I have a Fact Table with the goods issues (GI) ...
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Hi danandr87 ,

     

    Try to create a measure like below:

    Measure 2 = 
var total = 
CALCULATE([Measure],FILTER(ALL('Table'),'Table'[Period]="X"))
var count_x =CALCULATE(DISTINCTCOUNT('Table'[YYMM]),FILTER(ALL('Table'),NOT(ISBLANK([Measure]))&&'Table'[Period]="X"))
return DIVIDE(total,count_x,0)

     


    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

danandr87 , Create a measure

 

calculate(Averagex(values('Date'[YYMM]), calculate(sum(Table[QTY])) ) , allselected())

  • danandr87's avatar
    danandr87
    New Member
    4 years ago

    thanks for this answer, but it doesnt meet my requirement. For calculation of the average I want the quantities aggregated per month, but only for the months with PERIOD = X. But these months are not the months in my chart. So the calcualtion must somehow happen in the background ignoring any row and filter contexts, only considering the SKU as a filtering parameter.

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      4 years ago

      danandr87
      Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

      • danandr87's avatar
        danandr87
        New Member
        4 years ago

        I don't know how to attach a file to this forum and i am not allowed to upload files into a cloud with my work computer. But i took some screenhots of my simplified data model.

         

         

        FactTable:

         

        DateTable:

         

        This is my requirement: