We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
Average Line return incorrect value when in calculation grouo exists calculations like MOM, two SELELECTEDMEASURE, for example
SELECTEDMEASURE ()
- CALCULATE ( SELECTEDMEASURE (), SAMEPERIODLASTYEAR ( 'financials'[Date] ) )
is very easy make the error condition, using excel include in power bi (Financial),
1- make one simple measure
2- make one calculation groups with calc of style MOM o MOM %
remove calculation group item, and average line work fine
this problem not occurs with others analytics lines
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.