Some Values from Disconnected Table Missing in Matrix

[msmays5]

Hi all,

I have a disconnected table (PeriodCount) with values 0 to 30 in column [PeriodLength], which I have displayed across the columns of a matrix.

Additionally, I have a volume table that has hourly data for the latest 24 hours and daily data for the latest 30 days. In this table, there is a column denoting whhether the data is from 24h or 30d.

Via a slicer, I control whether I want to display 24h data or 30d data. When I choose the 30d data, all the columns display. However, when I choose 24h, every 3rd column starting at 2 is missing (2, 5, 8, 11, 14, etc.). The numbers look correct for all of the visible [PeriodLength], but I don't understand why every 3rd one is missing.

Here is my formula for the measure:

ClosePriceNPeriodsAgo =

VAR PeriodLength = SUM ( PeriodCount[PeriodLength] )

VAR PeriodDivsior= IF ( SELECTEDVALUE ( tblVolume[VolumeType] ) = "24h", 24, 1 )

VAR SubtractTime = PeriodLength / PeriodDivsior

VAR LatestLocalTime = MAX ( tblVolume[LocalTime] )

VAR DesiredTime = LatestLocalTime - SubtractTime

RETURN

CALCULATE (SUM ( tblVolume[closeSharePrice] ), tblVolume[LocalTime] = DesiredTime)

Any help would be greatly appreciated.

[amitchandak]

Can you share sample data and sample output. If possible please share a sample pbix file after removing sensitive information.Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[msmays5]

@amitchandak 
Please let me know if you can't view the attached. The matrix that is giving me trouble is on the table called Gains

https://1drv.ms/u/s!ApiFb_juj94X1mFAoTpHzLPu8GL3?e=zSJB6i