Forum Discussion

Jrich18's avatar
Jrich18
Frequent Visitor
5 years ago
Solved

Dealing with blank data - creating measures

Hi,   Im realatively new to power BI, im using a flat file to report on price movements of commodities. not all commodities have price data for each month.   My data table looks like this: C...
  • AlB's avatar
    AlB
    5 years ago

    Hi Jrich18 

    AVERAGE already ignores the blanks (not the zeros, of course). Use an AND instead of an OR:

     

    CALCULATE(AVERAGE('Weekly Master'[Price]), 'Weekly Master'[Price]<>0  &&  'Weekly Master'[Price]<>BLANK())

     

     

    		 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

     

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Jrich18 

AVERAGE already ignores the blanks (not the zeros, of course). Use an AND instead of an OR:

 

CALCULATE(AVERAGE('Weekly Master'[Price]), 'Weekly Master'[Price]<>0  &&  'Weekly Master'[Price]<>BLANK())

 

 

 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.