Matrix creating multiple period when new measure is inserted

Question

HiI have below matrix, when I filter only for FY24: P01 I get all the years for that period. Look like doesn't apply the filter (slicer)Diff_hours column measure below I appli :DIFF_HOURS = VAR Selection &nbsp; &nbsp; &nbsp; &nbsp; = SELECTEDVALUE (RESOURCE_RPT_HEADER[LOCATION]) -- location = Canada / United States of America / IndiaVAR overallocatedflag = CALCULATE([OVER_ALLOCATED_HOURS_FLAG], all(RESOURCE_RPT_HEADER[LOCATION])) -- this flag is "Y" when forecast hours &gt; BillsHours country Ex. 216 &gt; 152 VAR SelectCanada &nbsp; &nbsp; &nbsp;= SELECTEDVALUE (RESOURCE_RPT_LINE[CALENDAR.BillsHours_CA]) -- bills for canada Fy24:P01 = 152VAR SelectUS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;= SELECTEDVALUE (RESOURCE_RPT_LINE[CALENDAR.BillsHours_US])VAR SelectIndia &nbsp; &nbsp; &nbsp; = SELECTEDVALUE (RESOURCE_RPT_LINE[CALENDAR.BillsHours_IN])RETURNSWITCH (&nbsp; &nbsp; TRUE (),&nbsp; &nbsp; selection = "Canada" &nbsp;&amp;&amp; [OVER_ALLOCATED_HOURS_FLAG] = "Y",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF( &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -- If 216 &gt; 152 then 216-152 = 64 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SUM(RESOURCE_RPT_LINE[FORECAST_HOURS]) &gt; SelectCanada, &nbsp;(calculate(SUM(RESOURCE_RPT_LINE[FORECAST_HOURS])) - &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (SelectCanada)), 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; selection = "United States of America" &nbsp;&amp;&amp; [OVER_ALLOCATED_HOURS_FLAG] = "Y",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF( &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SUM(RESOURCE_RPT_LINE[FORECAST_HOURS]) &gt; SelectUS, &nbsp;(calculate(SUM(RESOURCE_RPT_LINE[FORECAST_HOURS])) - &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (SelectUS)) ,0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; selection = "India" &nbsp;&amp;&amp; [OVER_ALLOCATED_HOURS_FLAG] = "Y",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF( &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SUM(RESOURCE_RPT_LINE[FORECAST_HOURS]) &gt; SelectIndia, &nbsp;(calculate(SUM(RESOURCE_RPT_LINE[FORECAST_HOURS])) - &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (SelectUS)) , 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0)

anonymous · Accepted Answer

Thanks&nbsp;Team_Binbin Yu I founded the issue was in switch condition last sentence equal to 0...&nbsp;

Forum Discussion

Matrix creating multiple period when new measure is inserted

2 Replies

Related content

Creating multiple Audiences in PowerBI App

Insert multiple characters to string

Identity Insert On Warehouse table

Multiple messages when new item created

insert custom shape