Forum Discussion

Rodrivieiras's avatar
Rodrivieiras
Helper I
4 years ago
Solved

Average formula

Hello, I'm starting Power BI studies and I have a table called ProductSales with millions of data to analyze. Below is a sample of the data PERIOD   PRODUCT   PRICE 2001-07   TOY   10 2...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Rodrivieiras 
    Again my mistake

    AverageSold =
DIVIDE (
    COUNTROWS ( 'ProductSales' ),
    COUNTROWS ( VALUES ( Calendar[Month] ) )
)
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Rodrivieiras 

Sorry I misunderstood the question. Your approach is correct except a small detail.  If you are slicing by product then 

AverageSold = DIVIDE ( COUNTROWS('ProductSales'), VALUES(Calendar[Month])
)
Rodrivieiras's avatar
Rodrivieiras
Helper I
4 years ago

Hi tamerj1,

 

I tried your solution, but although the measure compiles successfully, I don't know how to check the result.

 

I used a card, but the following error message appeared:

"A table of multiple values was provided where a single value was expected"


The table view also didn't work.

 

Any clue?

Thanks

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Rodrivieiras 
    Again my mistake

    AverageSold =
DIVIDE (
    COUNTROWS ( 'ProductSales' ),
    COUNTROWS ( VALUES ( Calendar[Month] ) )
)
    • Rodrivieiras's avatar
      Rodrivieiras
      Helper I
      4 years ago

      Hi tamerj1 ,

       

      I just changed your formula a little bit by:

       

      AverageSold =
      DIVIDE (
                    COUNTROWS( ProductSales ),
                   COUNTROWS ( VALUES(ProductSales[PERIOD] ) 
      ))
       
      It worked perfectly!
       
      Thanks a lot!