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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.