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