KPI Card for current month only is displaying incorrectly

[Travis_rh]

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 is 0. I also have a single row, single value table for AvB which is also 0. The standard KPI card visual will display correctly (red when actuals > budget, green when actuals < budget) if I use the table version of AvB goal, but then displays Blank with green text when I use the measure version of AvB. 

1) What am I missing or what is not calculating correctly? 

2) Are there other KPI or Card visuals that might be able to handle this instance without issue? 

Below are some screenshots. 

[amitchandak]

@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]

@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]

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())))

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.