get a filtered value of PYTD

[Anonymous]

Hello all,

I have created measures of YTD(Current YTD) and LYTD(Previous YTD) and displaying in the matrix as shown in the screenshot below.

I am trying to filter the PYTD by type as shown below but results BLANK. Why does this happen ? If I filter YTD value by Type then it shows be the correct value.

PYTD NetSales = CALCULATE(VALUE([Final_TotalLYTD]), FILTER(ALLSELECTED(FinalTable), FinalTable[Type]="NetSales"))
YTD NetSales = CALCULATE(VALUE([Final_TotalYTD]), FILTER(ALLSELECTED(FinalTable), FinalTable[Type]="NetSales"))

Can anyone help me on this ? Thanks in advance ....

[amitchandak]

Your formula seems fine. unless you have some filter in [Final_TotalLYTD], or you have not typed "NetSales" correctly. Just copy-paste the YTD formula and change  the name and VALUE([Final_TotalLYTD]) and try

If possible please share a sample pbix file after removing sensitive information.Thanks.
Proud to be a Datanaut My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...