Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Avg-Based on New Measure

Hi Team,   I have two tables like With Markets and Without Markets,   With markets table -> combination of Markets & Code  without Markets -> Only code combination   Measures : (New Measures) ...
Need Help
TomMartens's avatar
TomMartens
Super User
5 years ago

Hey Anonymous ,

 

it's difficult, at least for me, to provide any guidance. It is not clear what you expect, meaning what's wrong with the 2nd table.

 

It's also no clear, if both tables are "just" visuals one without the markets columns, meaning both visuals are created using the same table from your data model.

 

Most of the time unexpected results on aggregated data (neglecting detail) are due to leaf level based algorithms, e.g. units * price eq revenue. To overcome this you have to use table iterator functions like SUMX.

measure = 
SUMX(
    '<tablename>'
    , '<tablename>'[units] * '<tablename>'[price]
)

 

Consider creating a pbix file that contains sample data, but still reflects your data model. Upload the file to one drive or dropbox and share the link. If you are using Excel to create the sample data share the xlsx as well.

 

Hopefully, this provides some ideas on how to tackle your challenge.

 

Regards,

Tom