Need help urgent

Nihed — Thu, 08 Jun 2023 23:23:29 GMT

Hello ,

I created this measure in Power BI:

Program Arreras =

var nbseldir =

CONCATENATEX(

SUMMARIZE('INCOME – Arrears Part II','INCOME – Arrears Part II'[Budget program.Budget program Level 01],

'INCOME – Arrears Part II'[Directorate],

"Balance Due", Sum('INCOME – Arrears Part II'[Balance Due])/1000),'INCOME – Arrears Part II'[Budget program.Budget program Level 01]

&" "&":"&" "&" "&

FORMAT([Balance Due],"Standard")

& UNICHAR(10))

return

nbseldir

which returns this result:

my obejectif is to display only programs with data and not to display empty programs,and I can’t get them off the screen.

Thank you,

Re: Need help urgent

tamerj1 — Fri, 09 Jun 2023 04:23:00 GMT

Hi Nihed
Please try

Program Arreras = CONCATENATEX ( FILTER ( SUMMARIZE ( 'INCOME – Arrears Part II', 'INCOME – Arrears Part II'[Budget program.Budget program Level 01], 'INCOME – Arrears Part II'[Directorate], "Balance Due", SUM ( 'INCOME – Arrears Part II'[Balance Due] ) / 1000 ), [Balance Due] <> BLANK () ), 'INCOME – Arrears Part II'[Budget program.Budget program Level 01] & " : " & FORMAT ( [Balance Due], "Standard" ) & UNICHAR ( 10 ), [Balance Due], DESC )

topic Need help urgent in DAX Commands and Tips

Need help urgent

Re: Need help urgent