cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

## I need help with a chart and a card

Hi I need help with the interaction of two graphs

When I take a point from the Fte's behavior graph, the card gives me that value divided by the number of days in the month, and not the same value that should be in the behavior graph

1 ACCEPTED SOLUTION
Community Support

I created some data:

Here are the steps you can follow：

1. Create measure.

``````True =
var _count=
COUNTX(
FILTER(ALL('Table'),    YEAR('Table'[Date])=YEAR(MAX('Table'[Date]))&&MONTH('Table'[Date])=MONTH(MAX('Table'[Date]))),[Date])
var _value=
MAX('Table'[Value])
return
DIVIDE(
_value,_count)``````

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

2 REPLIES 2
Community Support

I created some data:

Here are the steps you can follow：

1. Create measure.

``````True =
var _count=
COUNTX(
FILTER(ALL('Table'),    YEAR('Table'[Date])=YEAR(MAX('Table'[Date]))&&MONTH('Table'[Date])=MONTH(MAX('Table'[Date]))),[Date])
var _value=
MAX('Table'[Value])
return
DIVIDE(
_value,_count)``````

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.