Forum Discussion

sabariprabu's avatar
sabariprabu
Frequent Visitor
4 years ago
Solved

Measure based on only Date Filter Condition

Hi,    I have the below table data. Price amount is stored based on Year-Month and Type (Actual/Budget).   Year- Month field is having a relationship with Data Table. There are date, month and ye...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    4 years ago

    sabariprabu ,These measures should help 

     

    Actual= AverageX(Values(Table[Month Year]) , Calculate(Sum(Table[price]), filter(Table, Table[Type] = "Actual")) )

     

     

     

    Budget= AverageX(Values(Table[Month Year]) ,  Calculate(Sum(Table[price]), filter(Table, Table[Type] = "Budget")) )

amitchandak's avatar
amitchandak
Super User
4 years ago

sabariprabu ,These measures should help 

 

Actual= AverageX(Values(Table[Month Year]) , Calculate(Sum(Table[price]), filter(Table, Table[Type] = "Actual")) )

 

 

 

Budget= AverageX(Values(Table[Month Year]) ,  Calculate(Sum(Table[price]), filter(Table, Table[Type] = "Budget")) )