Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dax Formula Returning incorrect 2019 values

Hi Experts

 

See attached file sample data.

Dax measure in table Year_Grp mease name _v_Prd_Act

I am trying to populate 2019 values for my products into my table but the 2019 values are aggrating somehow with my measure 2020 is fine..

 

If you go to table Profitability Consolidation 

And filter as follows

1. Account Group = External Sales

2. Product = Diesel

3. Year = 2020 and 2019

4. Month (group) = Full

Look at channel = AFM for period 12 + 0 we have sales of 245.14 as per table visualization when we do the same for 2019 I am get 1,060.19, when the value should be 284.91..

Cannot see my error 

 

https://www.dropbox.com/s/8gftpnxon4uwmds/sample.pbix?dl=0 

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      All the file has become corrupted - trying to reproduced creat it

  • Anonymous , 

    File has been deleted on Dropbox. 

    Can you share the measure you are using or share any data to go through .

     

    Regards, 

    Manikumar