Power Bi Visual Question

[neodghale205889]

HI! I am having an issue with my visual populating incorrect values. Any help is appreciated!

So I have two measures that are basically identical, Grade 1 and Grade 2, just populate different results:

VAR FilteredRows =

FILTER(

    'PRODUCTION- Results',

    CONTAINSSTRING(

        'PRODUCTION- Results'[Grade],

        "1"

    )

)

VAR Sumof1 =

SUMX(

FilteredRows,

'PRODUCTION- Results'[Total Weight]

)

VAR TotalLbs=

CALCULATE(

    SUM('PRODUCTION- Results'[Total Weight]),

    ALL('PRODUCTION- Results'[Grade])

)

RETURN

CALCULATE(

DIVIDE(

Sumof1,

TotalLbs

)

)

I then created a measure Grade1andGrade2 that added these results together:

 [%ofGrade1]+[%ofGrade2]

The whole point of this is so that in my visual, I can easily filter out any items that are below 50%. So the idea is that if I create the measure Grade1andGrade2 and filter it to less than .50, it will only show my items where the combined Grade 1 and 2 are less than 50%.

However when I actually try to use this measure on the visual, it is still pulling the grades individually. So instead of looking at the combined grade 1 and 2 and filtering accordingly. It is looking at grade 1 and then grade 2, so the filter is incorrect.

[MFelix]

Hi @neodghale205889 ,

This depends on the columns you are using on your visual.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.