Sum of a column appears to be blank

[datewithoutdata]

Good morning,

I have imported a template to an application and the measures of 3 out of 4 queries synced. Measures of the other table (OPG) appear to be invalid. I tried to calculate a simple thing such as a sum and, I've got back a blank.

P.d.: The query has a relationship with the table called FechaComp that is a date-table. If I delete this relationship between FechaComp and OPG, I get a numerical result but not the correct one. Besides, the other queries are related to this table too, and they are not giving me any problem. Presupuesto Definitivo is related to another query called PGA.

Kind regards
Daniel

[datewithoutdata]

Good morning,

I have imported a template to an application and the measures of 3 out of 4 queries synced. Measures of the other table (OPG) appear to be invalid. I tried to calculate a simple thing such as a sum and, I've got back a blank.

P.d.: The query has a relationship with the table called FechaComp that is a date-table. If I delete this relationship between FechaComp and OPG, I get a numerical result but not the correct one. Besides, the other queries are related to this table too, and they are not giving me any problem. Presupuesto Definitivo is related to another query called PGA.

Kind regards
Daniel

[amitchandak]

@datewithoutdata , I doubt this can just happen like that. Either there is a filter on the page or at the visual level.

Put that column on a blank new page and check.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[V-lianl-msft]

Hi @datewithoutdata ,

Try: Measure =
CALCULATE(
SUM(OPG[Gastos xxxx]),
FILTER(OPG,OPG[YEAR]=MAX(Fechacomp[YEAR]))
)

If the problem persists,could you share the sample pbix with dummy data?

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-... 

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

[amitchandak · Accepted solution]

@datewithoutdata ,

I doubt this can just happen like that. Either there is a filter on the page or at the visual level.

Put that column on a blank new page and check.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[datewithoutdata]

I was trying to make a sample of the data and I realized I had an unrelated column filtered without null data. When I removed this filter, it worked correctly.

Kind regards,

Data