Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Nihed
Helper III
Helper III

Need help urgent

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:
 
Nihed_0-1686266334260.png

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,

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

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
)

View solution in original post

1 REPLY 1
tamerj1
Super User
Super User

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
)

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.