Forum Discussion

MacJasem's avatar
MacJasem
Icon for Advocate II rankAdvocate II
3 years ago
Solved

Flatlined values in a MTD table

Hi Guys Whats the esiest reusable method to discontinue flatlined values in YTD/MTD/WTD tables/graphs/BarCharts, such as this example: Data stops at 2. of February and thereby the chart flatl...
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, MacJasem 

     

    You can try the following methods.

    Measure = IF([TotalSalesValueMTD]=0,0,1)

    Result:

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

MacJasem's avatar
MacJasem
Icon for Advocate II rankAdvocate II
3 years ago

I figured it out by entering a filter in the dax measure ny using the ALLSELECTED function like this;

 

TotalSalesValueMTD =
CALCULATE ([SalesValue],
    DATESMTD ( 'Date'[Date] ),
          FILTER ( ALLSELECTED ( 'Date' ), 'Date'[Date] <= MAX ( FactSales[OrderDate] )))