Forum Discussion

RekhaG's avatar
RekhaG
Frequent Visitor
8 years ago

PowerBI -MDX Cube - YTD

Hi,

 

I have a Power BI Report where the data points are month-year(from date dimension) and a YTD measure.

 

The source is a multi-dimensional SSAS cube. The YTD Measure and month-year are taken from this cube.

 

 

The issue is( as seen in screenshot) when I select more than one year in the filter(of the date dimension), the YTD measure shows up as BLANK in the 'card' report and the total is blank in the 'table' report.  It shows the desired result only if one year is selected.

 

Any help is appreciated.

 

The MDX for the measure is

Sum
(
PeriodsToDate([Date].[Hierarchy].[Eff Year Num]),[Measures].[CountX]
)

Need Help

3 Replies

    • RekhaG's avatar
      RekhaG
      Frequent Visitor
      8 years ago

      Thank you for your response v-frfei-msft.

       

      I am using a multi dimensional cube as the source for my report. I cannot use TOTALYTD(DAX) on it.