filter and meter

[vhailor]

Hello

updated with real data and images.

I wanted to use the meter graph to display my data.

In my BBDD, I have a field to define whether it is maximum, minimum, target or actual data.

the id is heatid,the data is elementary,the category is chemistrytypecode

take quick action on the field but from what I see it makes me sum all the data, for example:

elemental para 10 = 
CALCULATE(
	SUM('ramses vista_analisisentradaHC'[elemental]),
	'ramses vista_analisisentradaHC'[chemistrytypecode] IN { 10 }
)

the result of this is that the measurements are not being filtered by the ID, but by displaying all the data.

how should I do this?

Thank you

[v-lionel-msft]

Hi @vhailor ,

Is this the problem?

Unless using hierarchical slicer.

Best regards,
Lionel Chen

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

[vhailor]

Updated

Thank you

@Greg_Deckler

@v-lionel-msft

[v-lionel-msft]

Hi @vhailor ,

Will the ‘Chart Name’ label aggregate your [ID] column?

What are the fields in each of the labels? Can you provide a screenshot of the report?

Or create a measure liek this?

__ID = SELECTEDVALUE(Sheet2[ID])

Best regards,
Lionel Chen

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

[Greg_Deckler]

@vhailor I am not following this, can you try explaining in greater detail what you are trying to accomplish?