Forum Discussion

Travis_rh's avatar
Travis_rh
Frequent Visitor
5 years ago

KPI Card for current month only is displaying incorrectly

Hi,   I'm trying to display a simple KPI based on a current month only actual versus budget (AvB) value. I have a measure that calculates current month variance and a measure for the AvB goal which...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Travis_rh , can you share the formula?

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Travis_rh's avatar
Travis_rh
Frequent Visitor
5 years ago

amitchandak 

 

The AvB goal measure is simply "AvB Goal Measure = 0" and it's formatted as English (U.S.) Currency. It's not easy to see, but is shown in the first screenshot, titled "KPI Incorrect with AvB Measure"

 

The AvB goal table is a single column and row of manually entered data with a value of 0. Here's a screenshot from the data view:

 

 

 

 

 

 

 

 

 

I also built a few tables to shown the data from the variance measures, AvB Goal measure, and AvB table side by side. 

 

 

 

 

 

 

 

 

 

Thank you! 

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hello @Travis_rh ,

    Perhaps the reason for your current month measure.

    You can add the ALLSELECTED function in a filter like this,

    Current month = CALCULATE(SUM('Table'[value]),FILTER(ALLSELECTED('Table'),MONTH('Table'[date])=MONTH(TODAY())))

    kpi1.jpg

    kpi2.jpg

    If you don't meet your requirements, could you show the exact expected result based on the table we shared?

    Best regards

    Community support team _ zhenbw

    If this post helps,then consider Accepting it as the solution to help other members find it faster.

    BTW, pbix as an attachment.