SummarizeColumns() and AddMissingItems() may not be used in this context

[Shahabh786]

Hi All,

I'm getting below error while using it in a measure.

Error: SummarizeColumns() and AddMissingItems() may not be used in this context

Measure: 

Highest Y-Axis = 
VAR _SummarizedTC1 =
    SUMMARIZECOLUMNS (
        'Calendar'[MonthYearName],
        'Products'[TherapyClass1],
        "@InvenotryDays", [Inventory Days]
    )
RETURN
MAXX ( _SummarizedTC1, [@InvenotryDays] )

Unfortunalty I can't use SUMMARIZE function because I need to calculate the inventory days against two column coming from two diffrent tables. 

Requesting you to kindly suggest any other way to achive the same result.

[Shahabh786]

Hi @Anonymous 

Basically I'm using measure [Highest Y-Axis] in asssigning Y axis value to a chart.

Inventory Days formula is simple, it is using sum of a column which produces values like. 50, 30, 80.

[Anonymous]

Hi @Shahabh786 ,

I tried to reproduce it. Below is the error.

I wonder what the [Inventory Days] measure formula looks like.

If you have a relationship between Calendar table and Products table.

You just drag three fields into a table visual. The result will appear.

If I'm wrong, please provide some simple sample data and expected result also as table form. It's like this dummy data in my reply.

Best Regards,

Stephen Tao

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