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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors