Need help urgent

[Nihed]

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,

[tamerj1 · Accepted solution]

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
)