Filtered measures in Matrix returning blank.

[jbageneau]

Hello,

I am using different measures calculated from the same table in a matrix visual

Here is the result when I switch values to rows (which is the wanted format)

What should I do to avoid the blank cells/rows? Filtering the visual did not work, neither did some changes in the DAX formulas.

Here is the data :

Date	KPI Name	Value
01.jan.23	KPI 1	2
01.feb.23	KPI 1	3
01.mar.23	KPI 1	5
01.apr.23	KPI 1	7
01.mai.23	KPI 1	4
01.jun.23	KPI 1	4
01.jul.23	KPI 1	3
01.aug.23	KPI 1	4
01.sep.23	KPI 1	8
01.okt.23	KPI 1	3
01.nov.23	KPI 1	1
01.des.23	KPI 1	7
01.jan.23	KPI 2	1
01.feb.23	KPI 2	1
01.mar.23	KPI 2	2
01.apr.23	KPI 2	2
01.mai.23	KPI 2	1
01.jun.23	KPI 2	2
01.jul.23	KPI 2	2
01.aug.23	KPI 2	1
01.sep.23	KPI 2	2
01.okt.23	KPI 2	1
01.nov.23	KPI 2	2
01.des.23	KPI 2	3

Here the DAX for the measure I am trying to create. I tried other things to no avail.

KPI 1 Measure =
    CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[KPI Name] = "KPI 1" )

KPI 2 uses the exact same DAX, with a different condition on the KPI Name columm.

Thank you very much for your help.

Best regards

[Anonymous]

Hi @jbageneau ,

May I ask if your problem has been solved. If the above reply was helpful, you may consider marking it as solution. If the problem is not yet solved, please feel free to ask us a question.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

[amitchandak]

@jbageneau , With current format, do not create measure for KPI

Just create measure Sum(Table[Value])

and use KPI on Rows as second field