Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |