Forum Discussion

Dronning's avatar
Dronning
New Member
1 year ago
Solved

DAX help

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 th...
  • Anonymous's avatar
    Anonymous
    1 year ago

    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's avatar
lbendlin
Super User
1 year ago

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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Dronning's avatar
Dronning
New Member
1 year ago

Okay good point i will do that. Tahnks