Measure returning a different value depending on the visual.

[varelapablo90]

Hello community

I have the following situation.

I've made a table that should only display information when there is input in 3 key values.

These are: 

- Company Code (a measure returns 1 when this field is filtered)

- Supplier (a measure returns 1 when this field is filtered)

- Invoice Reference (a measure returns 1 when this field is filtered)

3_way_match is the measure that sums the above measures, if all "mandatory inputs" are given result should be 3 and data table should be displayed, else would be less than 3 and nothing should show up.

As you see, despite the result is 2 in the table it returns 3, what could be the reason of this?

Table contains no duplicate values, its all unique and very basic star schema.

Look forward to hearing from you.

Thanks in advance

[Anonymous]

Hi @varelapablo90 ,

If I understand correctly, the issue is that the measure returning the error result. Please try the following methods and check if they can solve your problem:

1.Check the logic of each individual measure that they are indeed returning 1 when filtered.

2.Confirm that there are no unexpected relationships in the data model.

3.Ensure that there are no any other filters that apply to the report.

4.Verify the 3_way_match measure is using the correct formula to sum.

Best Regards,

Wisdom Wu

[varelapablo90]

What measures would you use to check if the values are selected?

[DataInsights]

@varelapablo90,

This behavior is due to filter context. The table visual has filter context for Invoice Reference, but the total row in the table visual and the card don't have filter context for Invoice Reference. How are you determining if a field is filtered? It would help to see your DAX.