Forum Discussion

lailailaieric's avatar
lailailaieric
Regular Visitor
9 years ago

Data Representation

Dear All   I have started to use PowerBI and I ran into this problem. I have looked online but seems like there are no solutions to it just yet.     As per below, these are the information I have.   ...
Need Help
lailailaieric's avatar
lailailaieric
Regular Visitor
9 years ago

Hi Phil

 

If thats the case, does it mean i have to use the table format again for this chart and I cant use other visuals?

 

Because the aim for me to when I click Asia, the number representating would appear, but when nothing is click "0.41" would show up. 

 

Thanks

 

 

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

The measure should work as expected and show the correct number.

 

Give it a try :)

  • lailailaieric's avatar
    lailailaieric
    Regular Visitor
    9 years ago

    Sorry Phil, 

     

    Do you mind showing it once to me, step by step how you can type in the formula?

     

    Because I am unable to locate the place to do so.

     

    Thank you so much for your help. 

     

    REally appreciating you helping me

    • Phil_Seamark's avatar
      Phil_Seamark
      Microsoft Employee
      9 years ago

      Hi lailailaieric

       

      Sure,  First of all make sure your table is highlighted,  Then from the modeling table, click the "New Measure" button

       

      Then 2) enter the forumla I posted above in step 2 ) but change the name of Table2 to be the same name as your table 

       

      • lailailaieric's avatar
        lailailaieric
        Regular Visitor
        9 years ago

        Hi Phil_Seamark

         

         Thank you for your helpful teaching. 

         

        Now that I have the new measures, would it be possible if I can do the same thing? Cause when I tried to add another measure, seems like they dont have this new measures as columns for me to pick from.

         

        Thank you so much.