Forum Discussion

vasathi's avatar
vasathi
Helper II
3 years ago
Solved

Sales Margin %

Team,

 

I would like to show my sales data based on the selected profit % values filled by users (i used what if parameter).

Below is my screen shot, 

 

 


Any help would be apreciated.

Thanks is advance

 

Kumar

 

Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi vasathi 

     

    Select the table visual, then apply a filter "is not blank" on Profit% field. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!

7 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    vasathi Measure seems fine. But Both COst and sales value are equal and profit ACY is 0. Based on that this seems to be working

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • vasathi's avatar
      vasathi
      Helper II
      3 years ago

      Sure, i will do share the sample.

       

      my question is as per the selection -20% to -5% , this table should not show any value, but here it is displaying.

       

      here i'm attaching sample data from adventure works.

       

      https://www.transfernow.net/dl/SampleFile

       

      Please help me.

      • v-jingzhang's avatar
        v-jingzhang
        Community Support
        3 years ago

        Hi vasathi 

         

        I checked your sample file. It seems the measure [Profit%] is working as expected. Where did you think it is not working? 

         

        Best Regards,
        Community Support Team _ Jing