QTD numbers are wrong

[Anonymous]

Hi Experts

Can not see the wood for the trees....Assume that you have the following data:

Jan 18     10000

Feb 18     5000

Mar 18    2000

Net Sales data...

When the user selects from the slicer Jan and the year 2018 the QTD information. should be just 10000....not the sum of the three months...cannot see the error the the YTD works correctly....

[v-piga-msft]

Hi @Anonymous,

More details will be better.

If it is convenient, could you share your formula and your problems?

Best Regards,

Cherry

[Anonymous]

Hi Cherry

When i select QTD from Slicer i get the full QTD numbers for any month i select. ...

[v-piga-msft · Accepted solution]

Hi @Anonymous,

Please share your data sample and your QTD formula so that I could test if there is anything wrong with your formula.

Best  Regards,

Cherrry

[Anonymous]

Hi Cherry - thanks for the excellent feedback. I worked out the solution error with my DAX formula.