Show blanks at the top level of a Matrix, it keeps showing some values from lower down

[Martyn_Cole]

Hi, 

I have a matrix, where I want to show blank values in the top level, I have applied HASONEVALUE as below but some cells are showing values not blank. Most seem to be where there is only 1 value lower down. 

The data only has a row if there is a planned loading on an activity, and does not have a row with a blank on it.

Planned Loading % =

IF(

    HASONEVALUE('FORWARD PLANNING'[Project ID & Title]),

    SUMX('FORWARD PLANNING',('FORWARD PLANNING'[PLANNED_HOURS])/('FORWARD PLANNING'[Working Hours Per Week Per Employee])),  -- Actual values for lowest level

    IF(

        HASONEVALUE('FORWARD PLANNING'[RESOURCE_DESCRIPTION]),

        SUMX('FORWARD PLANNING',('FORWARD PLANNING'[PLANNED_HOURS])/('FORWARD PLANNING'[Working Hours Per Week Per Employee])),  -- Summed values for middle level

        ""  -- blank for top level

    )

)

2024-06 etc. are weeks of the financial year. 

Sample data

RESOURCE_DESCRIPTION	PLANNED_HOURS	PROJECT_ID	FY & Week	WORKING HOURS PER WEEK
1000325	1	123	2024-14	7.5
1000325	2	123	2024-14	7.5
1000325	5	987	2024-14	7.5
1000325	0.05	123	2024-14	7.5
1000325	0.05	987	2024-14	7.5
1000325	0.05	987	2024-14	7.5
1000325	0.05	987	2024-14	7.5
1000325	6	987	2024-14	7.5
1000325	0.05	987	2024-14	7.5
1000325	0.05	987	2024-14	7.5
1000325	0.05	987	2024-14	7.5
1000325	8	987	2024-14	7.5
1000325	5	123	2024-14	7.5
1000325	5	123	2024-14	7.5
1000325	5	123	2024-14	7.5
1000325	8	987	2024-14	7.5
1000325	0.05	123	2024-14	7.5
1000325	0.05	123	2024-14	7.5
1000325	0.05	123	2024-14	7.5
1000325	0.05	123	2024-14	7.5
1000325	0.05	987	2024-14	7.5
1000325	9	123	2024-14	7.5

[lbendlin]

Please show the expected outcome based on the sample data you provided.

[Martyn_Cole]

I would like this please, blanks on all top level "resource group"

[lbendlin]