DAX value is not connected to the slicer

[Anonymous]

I need dax to add up MTD revenue.
The meaning is like this, when the year slicer is clicked it will add up the actual revenue from that year, but when the month slicer is clicked it will add up the actual revenue from the beginning of the year up to the month clicked earlier. For example, when the August slicer is clicked it will add up from the beginning of January to the end of August. However, when the slicer is not clicked it will add up from the beginning of the current year to the present.

Here is my current DAX,

Actual Revenue OI & FOI from MTD this year =

SUMX(

    FILTER(

        'Detail Project',

        'Detail Project'[Month] <= DATE(YEAR(TODAY()), MONTH(TODAY()), 1) &&

        'Detail Project'[Month] >= DATE(YEAR(TODAY()), 1, 1)

    ),

    'Detail Project'[Actual Revenue]

)

do you have a solution?

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Anonymous]

Here is an example of the data that I will display in Power BI, so there are 3 slicer job numbers, years, and months. When slicer years are pressed, it will add up the actual revenue of all months in that year, but when months are pressed, it will add up the beginning of the month of the year to the month pressed.

Job Number	Month	Years	Actual Revenue
A.23.1012	January 2023	2023	-
A.23.1012	February 2023	2023	-
A.23.1012	March 2023	2023	61.192.658
A.23.1012	April 2023	2023	195.816.504
A.23.1012	May 2023	2023	114.226.294
A.23.1012	June 2023	2023	36.715.595
A.23.1012	July 2023	2023	-
A.23.1012	August 2023	2023	-
A.23.1012	September 2023	2023	-
A.23.1012	October 2023	2023	-
A.23.1012	November 2023	2023	-
A.23.1012	December 2023	2023	-

[lbendlin]

What should happen if multiple years are selected?

[Anonymous]

summing up the selected years

[lbendlin]

Let's say you have two years and  two months selected?

[Anonymous]

Summing from the beginning of the year of the selected year to the last month of the most recent year selected, get it?

I'm open to other suggestions