Average Values Dynamically - What if

[HeitorLeao]

Hi, I have the following database and dynamic controls...
Data

Controls

I would like a measure that calculate the average value of multiply columns Scalar * Value but that also:

• Calculate the value regardless the time context (year, month, day and hour);
• The Scalar column can be modified by the controls above if the hour of the specific day attends to:
  • The year of the day is between the years of the control;
  • The hour classification matches with the control (control A multiply hours A);

Problem that I´ve found:

• The hour classification depend of the type of the day, so it´s possible to exits an hour "7" that is "A" in some specific day and another hour "7" as "B" in another specific day

Thanks for any help.

[daxer-almighty]

I would like a measure that calculate the average value of multiply columns Scalar * Value but that also:

• Calculate the value regardless the time context (year, month, day and hour);
• The Scalar column can be modified by the controls above if the hour of the specific day attends to:
  • The year of the day is between the years of the control;
  • The hour classification matches with the control (control A multiply hours A);

@HeitorLeao, sorry to say that but the above is about as clear as mud... I expect you won't get any replies unless you make it totally clear what you mean and what you want to get.

For instance, what does it mean "the scalar column can be modified"? If the column exists in a base table, it can't be modified by any measure... and if it exists in some visual, then... I can't understand what it is you want.