I need help with a chart and a card

[Syndicate_Admin]

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

[Anonymous · Accepted solution]

Hi  @Syndicate_Admin ,

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

[Ritaf1983]

Hi @Syndicate_Admin 

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.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523