Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello friends, I'm trying to create a table with the expression dax below, in Dax Studio the expression runs perfectly, but in the power bi desktop it presents an unidentified error. I'm putting Pbix to test so they can help me identify the error.
This expression ran normally and after the version update it stopped scrolling.
Expression running on dax studio
Expression running on PBI Desktop
EVALUATE SUMMARIZE( FILTER(TFExecucaoAtendimento, (TFExecucaoAtendimento[SkAceitabilidadeAtendimento]=15) && (TFExecucaoAtendimento[SkPublicoAlvo]=3 ||TFExecucaoAtendimento[SkPublicoAlvo]=4 ||TFExecucaoAtendimento[SkPublicoAlvo]=5) && (TFExecucaoAtendimento[SkSituacaoInstrumento]=2) && (TFExecucaoAtendimento[SkPPA]=201809) ), TFExecucaoAtendimento[SkSebrae], TFExecucaoAtendimento[CodRealizacaoSiac], TFExecucaoAtendimento[SkInstrumento], TFExecucaoAtendimento[SkClientePessoaJuridica], TFExecucaoAtendimento[SkIniciativa], TFExecucaoAtendimento[SkUnidadeOrganizacional_Iniciativa], "CodAtendimento", VAR CodOrigem = VALUES(TDOrigem[CodOrigem]) VAR CodRealSiac = FORMAT(VALUES(TFExecucaoAtendimento[CodRealizacaoSiac]),"GENERAL NUMBER") RETURN CONCATENATE(CodRealSiac,CodOrigem) )
Best Regards
Leudyston Dantas
Solved! Go to Solution.
Hi Leudyston,
I have reported t this issue to the Product Team: CRI 86194073. The workaround is replacing the VALUES with other functions like MIN, MAX, SELECTEDVALUE.
VAR CodOrigem = values(TDOrigem[CodOrigem])
BTW, Do not post sensitive data here.
Best Regards,
Dale
Hi Leudyston,
This issue has been fixed. Thank you for reporting it.
Best Regards,
Dale
Hi Leudyston,
I have reported t this issue to the Product Team: CRI 86194073. The workaround is replacing the VALUES with other functions like MIN, MAX, SELECTEDVALUE.
VAR CodOrigem = values(TDOrigem[CodOrigem])
BTW, Do not post sensitive data here.
Best Regards,
Dale
Hi Dale, thanks for your help.
The PBIX file is no longer available for download.
Best Regards,
Leudyston
Hi Leudyston,
The fix is expected in the November release. Thanks for your patience.
Best Regards,
Dale
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
70 | |
57 | |
37 | |
36 |
User | Count |
---|---|
85 | |
65 | |
60 | |
46 | |
45 |