Forum Discussion

ericOnline's avatar
ericOnline
Post Patron
6 years ago

MEASURE: Sum/Avg with Condition Question

Hello, I'm trying to create a measure that calculates the rank in one table based on conditions in another table.  Example: Here are the tables and relationship: The measure I have now to c...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  ericOnline 

When you click a record in the Rollup table (Table visual), it will filter other fields in the table visual too, not just Job Title field, so you'd better use a slicer instead it.

 

And if possible, could you please share your sample pbix file and your expected output? that will be a great help.

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Regards,

Lin

  • ericOnline's avatar
    ericOnline
    Post Patron
    6 years ago

    Hi v-lili6-msft . The Table selection filters many things on the screen. Its a logical "slicer" to use as it shows the Name/JobTitle/etc. 

     

    I can't share the .pbix file here as it contains private information. 

     

    Any other ideas on how to get this measure put together?

    • v-lili6-msft's avatar
      v-lili6-msft
      Community Support
      6 years ago

      hi  ericOnline 

      If possible, could you please use dummy data to create a sample pbix file, that will be a great help.

       

      Regards,

      Lin