Forum Discussion

bjackson2760's avatar
bjackson2760
Icon for Helper I rankHelper I
10 months ago
Solved

Sum dynamic parameter fields multiple selected parameter

Here is my scenario: I have 2 parameters with the same amount of colums and I need to be able to select from each of the 2 parameters one or more fields that will sum depending on what fields are se...
Need Help
  • v-dineshya's avatar
    v-dineshya
    10 months ago

    Hi bjackson2760 ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    I have created sample data . Please refer below snap.

     

     

    Please refer below output snap and attached PBIX file.

     

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Regards,

    Dinesh

tharunkumarRTK's avatar
tharunkumarRTK
Icon for Super User rankSuper User
10 months ago

bjackson2760  

As   danextian  explained, you would require a lenghty dax measure if you choose field parameter approach for your scenario. I would suggest you to 

1. Unpivot your data if not already

2. Create two different diconnected tables for your slicers

3. Create a dax measures with kind of pattern

ValueMeasure = 
Var __ValuesOfDates = UNION( VALUES(DisconnectedDate1[Date]) , VALUES(DisconnectedDate2[Date])) 
Var __Result  = CALCULATE(SUM(UnpivotedData[Value]), KEEPFILTERS( TREATAS(__ValuesOfDates, UnpivotedData[Month]))) 
RETURN __Result

4. Thats it

You will be able to achieve the expected result

You can download the report from here

 

 

 

 

Connect on LinkedIn

 

 

 








Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!
bjackson2760's avatar
bjackson2760
Icon for Helper I rankHelper I
10 months ago

Hi can you provide a sample report?