One object summarizes always, even though it's set to Do Not Summarize

[RLSmart]

I have a SSAS model as a data source in PBI. 

One of the tables has a series of columns with a 1/0 value.  I use the column itself as a flag, then i have measures that sum(), etc.  

All of these columns are the same datatype in the source database, same format in SSAS (whole number) and all of them behave correctly except for one, which whenever I add it to a viz, applies the Average summarization to it.  I can add it to a viz, change it to Don't Summarize, remove it and add it back in and it will do the same again.  

[ETA] The viz I am using is just a Table, not a chart, so i would not expect any aggregation, these are attributes, not facts.  

Here's the definition of the bad guy (is paper statements fee) and one that is normal.  

{
"name": "Is Paper Statements Fee",
"dataType": "int64",
"description": "Source Code is F and Comment contains Paper Statement or Statement Copy",
"sourceColumn": "Is Paper Statement Fee",
"formatString": "0",
"displayFolder": "_Indicators",
"summarizeBy": "none"
},

{
"name": "Is Money Market Fee",
"dataType": "int64",
"description": "Source Code is F and Product is a Money Market",
"sourceColumn": "Is Money Market Fee",
"formatString": "0",
"displayFolder": "_Indicators",
"summarizeBy": "none"
},

I have already completely removed the column from the table, deployed the model, then added it back and redeployed and still it's behaving like this.  

Any suggestions on how I can fix this? 

[Anonymous]

Hi @RLSmart ,

If you are not using the live connection mode, I'd like to suggest you enter to query editor to check these fields and do formatting operations. (AFAIK, current power bi will break the original data field(columns and measures) structure and use text value to recognize your fields if you are using import mode to get data from AS data source)

Regards,

Xiaoxin Sheng

[RLSmart]

There is no query editor when SSAS is the data source. 

[amitchandak]

If it is not a live connection. Then in Model/DATA view go and change its data type to text and see if works

[RLSmart]

This is not an option when using SSAS as the data source.  You define everything in SSAS. 

[Anonymous]

Hi @RLSmart ,

Could you please show some screenshots of the error and details for this error?

Thanks.

Aiolos Zhao

[RLSmart]

The 3rd column should look like all of the others, a list of 1 or 0.  Instead it's nonsense in this context.   

This shows how it looks in the table visualization: 

This is how it looks in the Visualizations column: 

and here is how it looks when I click the arrow to show the details: 

[Anonymous]

Hi @RLSmart ,

What version of tools are your works on? If you are working on the old version, have you consider to migrate/rebuild your project with the latest version tool/instance? (power bi desktop data model are based on the last version of AS tabular, it may cause the compatibility issues between old version tools and latest version AS tabular instance)

Regards,

Xiaoxin Sheng