Repeated Labels and Values Matrix table

Thanks for the reply from lbendlin , please allow me to provide another insight:

Hi, ELToninio 
 

1.Regarding your first question, you might consider using the NOT() and IN() functions, modifying it to the following example, which will allow you to add multiple values for evaluation:

IF(
    FiltreSubcategoryRunning = true() && 
    NOT(SELECTEDVALUE('Nature of Running Costs'[Nature of running costs]) IN {"N07 - Travel expenses", "Other Value 1", "Other Value 2"}),
    BLANK(),
    ...
)

2.As for your second question, the issue of subcategory labels appearing under each Nature of Running Costs and the repetition of subtotals typically stems from your relationship and model settings.

Firstly, you should check whether your relationship configurations are set up correctly.

Secondly, verify that the hierarchy settings in your matrix are accurate.

For further details, please refer to:

Dealing with Measure Totals - Microsoft Fabric Community
Measure Totals, The Final Word - Microsoft Fabric Community
Solved: No total value for measure - Microsoft Fabric Community

In this regard, we suggest that you upload some sample data for us, as this will facilitate a more specific analysis of the issues at hand.

When uploading a file, please be careful to delete sensitive information.For questions about uploading data, you can try the following links:

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Solved: How to upload PBI in Community - Microsoft Fabric Community

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.