Forum Discussion

SagarChauhan1's avatar
SagarChauhan1
Icon for Helper I rankHelper I
5 months ago
Solved

Help with Parameter and slicer with measure

Hello,

 

Please help me with below where out should be total of slicer selection. Only 1 column needs to be there.

Ashish_Mathur 

 

 

Data Protection
General Comment
  • grazitti_sapna's avatar
    grazitti_sapna
    5 months ago

    Ok SagarChauhan1 ,

     

    The solution is provided on the other post, kust remove all the columns and only keep total_Measure column, it'll work as required, I'm attaching the solution here too, where i've removed all the three columns. I've created three separate measure but you can use the columns directly as field parameters and it should work fine for you.

  • Anonymous's avatar
    Anonymous
    5 months ago

    Hi SagarChauhan1,

    I would also take a moment to thank grazitti_sapna  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
     

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

    Regards,
    Community Support Team.

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 months ago

    Hi SagarChauhan1,

    I would also take a moment to thank grazitti_sapna  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
     

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

    Regards,
    Community Support Team.

  • grazitti_sapna's avatar
    grazitti_sapna
    Icon for Super User rankSuper User
    5 months ago

    Hi SagarChauhan1,

     

    Could you elaborate more about your query, a single sentence does not explain.

     

    If you want the slicer to select only one item at a time, you can do it in slicer settings and deslecte Multi selecte and select single select Option

     

    If this is not what you are looking for, please explain a bit more about the requirement.

     

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
    💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
    🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
    🔗 Curious to explore more? [Discover here].
    Let’s keep building smarter solutions together!

  • SagarChauhan1's avatar
    SagarChauhan1
    Icon for Helper I rankHelper I
    5 months ago

    Hello,
    Currently there are 3 colums which are coming from Table as below.

    I have a parameter as below.

    I need only 1 column with the output of sum of slicer selections,

    If we select only Mfg Cost then answere in that output column should be 72
    If we select two Mfg Cost + Duty then answere in that output column should be 86.40

    If we select all three Mfg Cost + Duty + Royalty then answere in that output column should be 93.60.

    Hope this helps.

     

    • grazitti_sapna's avatar
      grazitti_sapna
      Icon for Super User rankSuper User
      5 months ago

      Ok SagarChauhan1 ,

       

      The solution is provided on the other post, kust remove all the columns and only keep total_Measure column, it'll work as required, I'm attaching the solution here too, where i've removed all the three columns. I've created three separate measure but you can use the columns directly as field parameters and it should work fine for you.

      • SagarChauhan1's avatar
        SagarChauhan1
        Icon for Helper I rankHelper I
        5 months ago

        Thank you so much Ma'aam for the perfect solution. Appreciate your time and efforts.