Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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 , 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.
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?
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |