Hi I have a measure that calculates TotalProducts and I would like to now calculate Average([TotalProducts]) based on Region column. Can someone please help on how to get this. Please see below measure calculation
Solved! Go to Solution.
Could you plese try to add a region count measure?
Regioncount= distinctcount ('Product'[Region])
Average= Divide (TotalProducts, Regioncount)
Hope this is helpful for you. Thanks
Based on your description, formula TotalProducts is the formula below you have posted, right?
TotalProducts = CALCULATE ( CALCULATE ( DISTINCTCOUNT ( 'Product'[ProductNumber] ), FILTER ( 'Product', ISBLANK ( 'Product'[Modified Date] ) = FALSE () ), USERELATIONSHIP ( DateTable[Date], 'Product'[Created Date] ) ) + 0 )
If the formula is measure, change it into calculate column and try again.
Thanks for your reply. I would like try using measures rather than custom column. This is what I need.
|NEWCASTLE UPON TYNE||457||28.00438|