Hello ,
I created this measure in Power BI:
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,
Solved! Go to 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
)
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
)