Forum Discussion

akemr's avatar
akemr
Icon for Helper II rankHelper II
6 years ago

Row Card showing incorrect value compared to local dataset

Hi all,

 

Below are screenshots of what my local dataset looks like and what the row cards in my report look like. I've used a measure to introduce decimal places, but the digits should be the same. I'm trying to show the sum of FY19 Pd (which is the last value in FY19 Cumulative) and FY20 Pd (last value in FY20 Cumulative)

 

I have no idea why this change of (5531 to 5532) and (5266 to 5265) is occurring. Any ideas?

 

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    akemr , Not very cleat

     

    FY 19 Full year = sum(Table[FY 19 PD])

    FY 20 Full year = sum(Table[FY 20 PD])

     

    diff = [FY 20 Full year] - [FY 19 Full year]

    diff % = divide([FY 20 Full year] - [FY 19 Full year], [FY 19 Full year])

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi akemr ,

     

    Try using the ROUND() function

     

    https://dax.guide/round/

     

    Regards,
    Harsh Nathani
    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

  • swise001's avatar
    swise001
    Icon for Continued Contributor rankContinued Contributor
    6 years ago

    akemr 

     

    Can you share your measures?  

     

    This is definitely where the issue is.  Wrap your measure in a ROUND() function or re-think how you want to calculate it.  If you already have the value in your data table - consider alternative routes to get 5531 to 5.531 (divide by 1000?, etc).  

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi akemr ,

     

    Have you resolved this issue? If yes, can you please accept the helpful answer as solution? You also could share your own solution. If you still need help, please share more details with us, like your formulas. It is better to share a dummy pbix. Then we will understand more clearly. Thanks.