Embedding without hard-coding master credentials (app owns data)

[WelterM]

I have three columns, as shown in the image. When I added the 3rd column, the rows got duplicated. Why is that? How do I prevent it? You can see the formula for the 3rd column. It is just a hard coded value. It's just a placeholder for now. But there should only be two rows, not four. What's going on here?

[parry2k]

Interesting!!

Just curious, if you remove this "Pipeline Coverage Ratio", do you get two rows?

Are there multiple table ? If yes, how those are related?

[WelterM]

Yes, if I remove Pipeline Coverage Ratio, the table collapses to two rows. It's weird. All columns are coming from the same table.

[parry2k]

This is very bizzare.

How about if you don't use count and put all three columns, you except to see table with N/A for each row. Basically try to find out if there will be a case when this field has blank value instead of N/A

On other note, so you are saying your model has only one table or you have more than table and they have relationship, regardless even if you are showing columns from one table. Just trying to understand the problem here, very interesting.

[WelterM · Accepted solution]

Yes, I have many tables in the model, but these columns are all coming from the same table.

As an experiment, I tried re-creating Pipeline Coverage Ratio as a Measure (Same formula), and it worked as expected. It shows just 2 rows now, with "N/A" is each row. Go figure.

Thanks for your help.

[parry2k]

Very interesting, as you confirmed that data is coming from same tables, not sure why it wouldn't work if you added as a column.

Surely relationship with other column has something to do with it, cannot comment until I see the setup.

Anyhow, glad it is working, will leave it here for now..