Forum Discussion

vhailor's avatar
vhailor
Frequent Visitor
5 years ago

filter and meter

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 }
)

chart.png

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

Need Help

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

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

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    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.

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    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.