Issue with formula

[adoalan]

Hi,

I have an error with this formula. Instead of getting one line like below

I get this

When I remove the formula

Is giving the correct results but that formula is giving me a trim from source code column so I need to keep it.

Any idea how to fix this issue?

[v-yangliu-msft]

Hi  @adoalan ,

Are you referring to the increase in data after placing Measure into Visual?

You can check if there are other filtering conditions or if your data are from the same table, generally speaking, in the same table no matter how to filter, Measure's results will follow the filtering conditions to display, and will not redundantly copy increased data, if the data are in different tables, this situation may occur because of the relationship between the two tables.

Best Regards,

Liu Yang

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