CONCATENATEX contex issue

zenton — Wed, 06 Jul 2022 05:27:53 GMT

Hi, I need help with concatenatex measure.

Result in a table with LIMS Text ID gives correct result

When I remove LIMS Text ID I get incorrect result

The result I rerquire is the concatenation of all results Selenium, Zinc Copper.

Thanks Rodney

Calulations:

Limiting Contaminants Cont =
VAR VisualValues =
    CALCULATETABLE (
        ADDCOLUMNS (
            SUMMARIZE (
                Labware,
                RMD_tlkp_AnolyteMasterList[strLegendName],
                '2DateTable'[Date]
            ),
            "@Grade", Labware[Grade]
        ),
        ALLSELECTED ()
    )
VAR MAXGRADE =
    CALCULATE (
        CONCATENATEX (
            RMD_tlkp_AnolyteMasterList,
            RMD_tlkp_AnolyteMasterList[strLegendName],
            ", "
        ),
        FILTER ( RMD_tlkp_AnolyteMasterList, [Grade] = MAXX ( VisualValues, [@Grade] ) )
    )
RETURN
    MAXGRADE

Grade =
SWITCH (
    TRUE (),
    'Labware'[CtA] < 3.5, "A",
    'Labware'[CtB] < 3.5, "B",
    'Labware'[CtC] < 3.5, "C",
    'Labware'[CtD] < 3.5, "D",
    "E"
)

Re: CONCATENATEX contex issue

daXtreme — Wed, 06 Jul 2022 06:28:08 GMT

Hi zenton

With the amount of info given, one can't build a good formula. One needs to know why you get the results in the second picture and why it's incorrect. That calls for the understanding of the underlying data.

Re: CONCATENATEX contex issue

zenton — Thu, 07 Jul 2022 00:01:55 GMT

Hi daXtreme
The underlying data and calciulations are to complex to share. I will close this discussion and try to ask question differently

topic CONCATENATEX contex issue in DAX Commands and Tips

CONCATENATEX contex issue

Re: CONCATENATEX contex issue

Re: CONCATENATEX contex issue