Fied parameter für x,y-Diagram

[Spurgeon74]

What could be the problem here in the xy-diagram? For the table below it works...

Looking forward to your reply

[v-jianpeng-msft · Accepted solution]

Thank you MFelix

Hi, @Spurgeon74 

If you try to use SELECTEDVALUE for the visible columns of a table generated by the Field Parameters feature in Power BI, you receive your current error. You can check out an article that SQLBI just posted:

Using SELECTEDVALUE with Fields Parameters in Power BI - SQLBI

The following case also encountered the same problem, and then solved his problem according to the SQLBI article:

Solved: Field Parameters - Dynamic Visual Title - Microsoft Fabric Community

Best Regards

Jianpeng Li

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

[MFelix]

HI @Spurgeon74 ,

Can you please share the details of the error you are getting?

[Spurgeon74]

Hi Miguel!

I get the following message: MdxScript(Model) (5,5) Calculation error in measure "Clearwater"[SelectedColumn]: Column [SelectionAnalyte] is part of the composite key, but not all columns of the composite key are included in the expression or its dependent expression.

But I use the same fields in the table below the diagram 

[MFelix]

You are using a measure what is the syntax of the measure?

If you use the value from the field parameter that should work properly:

[Spurgeon74]

AusgewählteSpalte =

SWITCH(

    SELECTEDVALUE('AuswahlAnalyt'[AuswahlAnalyt]),

    "Antimon (mg/L)", AVERAGE('Klarwasser'[Antimon (mg/L)]),

    "Quecksilber gelöst (mg/L)", AVERAGE('Klarwasser'[Quecksilber gelöst (mg/L)]),

    "Sulfat (mg/L)", AVERAGE('Klarwasser'[Sulfat (mg/L)]),

    "Bromid (mg/L)", AVERAGE('Klarwasser'[Bromid (mg/L)]),

    "Chlorid (mg/L)", AVERAGE('Klarwasser'[Chlorid (mg/L)]),

    "Nitrat (mg/L)", AVERAGE('Klarwasser'[Nitrat (mg/L)]),

    "Nitrit (mg/L)", AVERAGE('Klarwasser'[Nitrit (mg/L)]),

    "Phosphat (mg/L)", AVERAGE('Klarwasser'[Phosphat (mg/L)]),

    "Fluorid (mg/L)", AVERAGE('Klarwasser'[Fluorid (mg/L)]),

    BLANK()

)