DAX help

[Dronning]

Hello!

I cant solve this problem by my own

Problem:
 What i want to happen is for the chosen dates in a date slicer i want to SUM('Omrade 2'[Värde]) a numeric column for each chosen date in the slicer and multiply that value by a factor from a numeric decimal parameter.  And for the dates that are not chosen in the slicer i want the SUM('Omrade 2'[Värde]) to always be multiplied by a factor of 1.

I want all the data to be visable in the vizualisation all the time so the dateslicer shall not filter that vizualisation. But only decide wich dates to multiply with the numeric parameter.


So for example if i chose the dates 2025-01-01 & 2025-01-04 in the dateslicer i only want these two dates to be mulitiplyed by the numeric parameter and the rest of the dates to multiply by 1.
So when i change number in the numeric parameter the values for the dates 2025-01-01 & 2025-01-04 shall be changed and the rest stay the same.


I have a fact table with numeric values and dates.
And a date table with countinouse dates.
And a numeric parameter with range from 0 -2 in steps of 0,01


Thanks in advance 

[Anonymous · Accepted solution]

Hi @Dronning ,

It's better if you provide us with sample data and expected result next time as lbendlin said.

I created some dummy data and implement. Please refer to

Measure = IF(MAX('Table'[Date]) in ALLSELECTED(Dates[Date]),SUM('Table'[Value])*[numeric parameter Value],SUM('Table'[Value])*1)

Pay attention that there's no relationship between Dates table and the main table.

You can download my attachment for more details.

Best Regards,
Stephen Tao

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

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Dronning]

Okay good point i will do that. Tahnks