Forum Discussion

emma313823's avatar
emma313823
Icon for Helper V rankHelper V
2 years ago
Solved

Values in table and new card visual not displaying correctly

All,   I am unable to get a 'new card' visual and table to display the correct value.   The correct value for my July data should show as $237,368.12, however my card visual is showing as $237,37...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hola emma313823. Revisa que las medidas CurrentMoComm y PrevMoComm no tengan la formula Round.

    Te muestro el cambio de valor usando la formula round que tiene menos dos decimales.

     

     

    Si respondí tu pregunta, ¡Marca mi publicación como solución! ¡Esto ayudará a otros en el foro!

    ¡¡Aprecio tus felicitaciones!!

     

  • emma313823's avatar
    emma313823
    2 years ago

    Hi

    OH MY GOD. Thank you so much for your help on this. I went in to transform data and set it to fixed decimal and after accepting the changes my visuals displayed the way I was hoping.

     

    You are the best!!

    Emma

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hola emma313823. Revisa que las medidas CurrentMoComm y PrevMoComm no tengan la formula Round.

Te muestro el cambio de valor usando la formula round que tiene menos dos decimales.

 

 

Si respondí tu pregunta, ¡Marca mi publicación como solución! ¡Esto ayudará a otros en el foro!

¡¡Aprecio tus felicitaciones!!

 

  • emma313823's avatar
    emma313823
    Icon for Helper V rankHelper V
    2 years ago

    Hi - this came in for some reason as spanish, so hopefully I translated it properly. I'm not sure how to tell if this has rounding built into the measure.

     

    CurrentMoComm measure DAX

    CurrentMoComm =
    CALCULATE(
    SUM('tblIncomingCommissions'[Check_Value]),
    FILTER(
    'Calendar_Dates',
    MONTH('Calendar_Dates'[Date]) = MONTH(TODAY()) &&
    YEAR('Calendar_Dates'[Date]) = YEAR(TODAY())
    )
    )
     
    PrevMoComm Measure
     
    PrevMoComm =
    CALCULATE(
    SUM('tblIncomingCommissions'[Check_Value]),
    FILTER(
    'Calendar_Dates',
    MONTH('Calendar_Dates'[Date]) = MONTH(TODAY())-1 &&
    YEAR('Calendar_Dates'[Date]) = YEAR(TODAY())
    )
    )