Measure used in MAX statement

Question

DEFINE
    MEASURE 'DAX BSS Measures'[Test_measureNEW] =
        VAR date_field =
            MAX ( STG_JIRA_ISSUE[Created] )
        VAR date_value =
            DATE ( YEAR ( date_field ), MONTH ( date_field ), DAY ( date_field ) )
        VAR release_date =
            CALCULATE (
                MIN ( CONF_SPRINT_CALENDAR[Release Date] ),
                FILTER (
                    CONF_SPRINT_CALENDAR,
                    CONF_SPRINT_CALENDAR[Start Date] &lt;= date_value
                        &amp;&amp; CONF_SPRINT_CALENDAR[Release Date] &gt;= date_value
                        &amp;&amp; CONF_SPRINT_CALENDAR[Country]
                            = MAX ( STG_JIRA_ISSUE[Country (Extracted) Sprint] )
                        &amp;&amp; CONF_SPRINT_CALENDAR[Project Key] IN { "BS", "SEL" }
                )
            )
        VAR filter_defects =
            FILTER (
                ADDCOLUMNS (
                    STG_JIRA_ISSUE,
                    "Defect Sprint Date", DATE ( YEAR ( release_date ), MONTH ( release_date ), 1 )
                ),
                [Defect Sprint Date] = MAX ( [Defect Sprint Date] )
            )
        VAR bss_sweden_defects =
            CALCULATE (
                COUNT ( STG_JIRA_ISSUE[ID] ),
                filter_defects,
                STG_JIRA_ISSUE[Country (Extracted) Sprint] = "Sweden"
            )
        RETURN
            bss_sweden_defects
EVALUATE
FILTER (
    ADDCOLUMNS ( STG_JIRA_ISSUE, "Number of Defects", [Test_measureNEW] ),
    NOT ISBLANK ( [Number of Defects] )
)My logic in this code was following:1. Based on Created dated find Sprint Release Date;2. Then based on Release Date&nbsp;(only Month is needed) count number of Issues per Month.Result of my query is error: "Table 'DAX BSS Measures' cannot be used in computations because it does not have any columns."Issue is in Variable filter_defects,&nbsp;DAX doesn't like MAX( [Defect Sprint Date] ), which is separate column created within FILTER.Is there solution, how to solve my issue?

tommartens · Accepted Answer

Hey,
&nbsp;
there are some things you have to consider.
&nbsp;
You can't use ADDCOLUMN(...) to add a column to an already exisiting table 'STG_Jira_Issue'.
&nbsp;
I'm not sure from where the table originates, if it's a table that you compose with SSDT you might consider to add a CALCULATED COLUMN, if it's a table that you "import" into Power BI, create a calculated column.
&nbsp;
Hopefully this gives you an idea.
&nbsp;
Regards,
Tom

Forum Discussion

Related content

IF Statement using Power Query

PowerBI measure IF statement

Using IF statement with measure

Measure IF statement for each row

If Statement in Measure