Issues When Adding New Fields

[dyee4613]

The past few days, I've noticed that adding certain fields makes my data act strangely.  I was wondering if anyone had any idea why this was happening so I could detective/resolve it sooner.  Here is my first table.  All the data in this table comes from the same table.

This is the same table.  I'm just adding the driver field which is a text field.  

As you can see,  the measure is now messed up.  This doesn't make sense to me because everything is in the same data table.  In another example, I had a data model that utilized multiple fields and worked fine.  However, when I added a certain column to the table certain rows suddenly disappeared.  Does anyone know the cause for this so I can hopefully avoid this error in the future?

[Anonymous · Accepted solution]

HI @dyee4613 ,

According to your description,it seems like you add a new text fields to table visual.

When you add new fields which not able to apply calculation aggregations, it will be recognized as category fields and re-group original row content which will affect original value fields summarize and measure calculate.

For your scenario, you need to modify your measure formula to add condition or if statement to ignore the calculation on specific contents.

If you confused on coding formula, can you please share sample data and more detail information for test?

Regards,
Xiaoxin Sheng

[dyee4613]

@Anonymous  Thanks for your response! I'll keep an eye out for the category fields.  However, I'm still confused why two columns with the same data type would act so differently.  I can understand if Power BI can't figure out how to aggregate a text field leading to the error but I would think it would apply to all text fields as I wouldn't think a field with the word blue would be structurally different from a different field with the word popcorn.