Forum Discussion

IF's avatar
IF
Icon for Post Prodigy rankPost Prodigy
4 years ago

measure for specific value

Hi,

It is complicated to explain the report, therefore, I uploaded it to dropbox. 

https://www.dropbox.com/s/71lgsh3jj7788s2/Question_Measure.pbix?dl=0

 

The measure works except for the region. if I select EU, it should show 65. Similarly, it should show 75 for AM.

Can you help me for correcting the measure?

Thanks in advance!

 

 

Need Help

4 Replies

  • TheoC's avatar
    TheoC
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi IF 

     

    The reason it is not working as you want is because your Region slicer is looking to the main table to find you only "AM" region or only "EU" region... because there are many AMs and many EUs in your data, you need to also select the other slicers that match the rows like below:

    By selecting the slicers in your PBIX that match the above table, you can get exactly what you are wanting:

    I hope this helps 🙂

    Theo

     

     

    • IF's avatar
      IF
      Icon for Post Prodigy rankPost Prodigy
      4 years ago

      Hi, thanks for your response. i am interested in getting the result by selecting only the region slicer.

      • TheoC's avatar
        TheoC
        Icon for Community Champion rankCommunity Champion
        4 years ago

        Hi IF 

         

        To achieve that, you need to remove some of your data in your Main table.  The reason for this is because you want Power BI to only give you one number when you have given Power BI five numbers to choose from.