Forum Discussion

CarlBlunck's avatar
CarlBlunck
Resolver I
2 years ago

MdxScript(Model) (20,1) calculation error

I am getting this : MdxScript(Model) (20,1) calculation error Calculation error in measure 'Sheet1'[Dynamic_WIPv2]: SummarizeColumns() and AddMissingItems() may not be used in this context.     Her...
Need Help
CarlBlunck's avatar
CarlBlunck
Resolver I
2 years ago

Hi 123abc 

Thanks for the response and updated approach!  That get's me close. Here is a link to the pbix file - https://drive.google.com/file/d/1n4Jbbml3_nw4UmdByPYTeOD2bhPiJ2B1/view?usp=drive_link

 

When I calculate this in excel manually, I get a result of $45,580.85.  But the measure is computing a result of $31,200.

 

I need to be able to have the filter of Sheet1[invoiceid] = MAX(Sheet1[invoiceid]) applied for each distinct Sheet1[Simpro jobid].  That is really key.

 

Cheers

Carl

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi CarlBlunck ,

If it's just the total value of the measure that's wrong, try adding another measure based on this one created by AnalyticPulse .

Dynamic_Wipv3 =
VAR _a = table[Dynamic_WIPv2]
VAR _b =
    SUMMARIZE ( table, table[date], "aaa", table[Dynamic_WIPv2] )
RETURN
    IF ( HASONEVALUE ( table[date] ), _a, SUMX ( _b, [aaa] ) )
//table[date] can be changed to a column with a unique value in the table.//

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.