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

Anonymous's avatar
Anonymous
Not applicable
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