cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper V
Helper V

Need Help

I have Organization  Names as well as Job Numbers. Each Organization generally has multiple jobs.  I need to show Organizations that do not have MRB jobs. I have a column that classifies a JOB as "MRB" or "Not MRB" but can't seem to figure out how to apply it to the Organization level.

 

So when I use a slicer to only show "MRB" or "Not MRB," many organizations show up on both lists because it's filtering it by Job NUmber

6 REPLIES 6
Resolver III
Resolver III

Hi,

 

You can duplicate the table you are using, then filter to show only rows with MRB then remove duplicates. after it add a new column with the value 1 with the title "MRB CUSTOMER FLAG"

after that, go back to your original table and do left join for new table (join it by customer name or ID), expend the MRB CUSTOMER FLAG column and replace the null values with 0.

when you done you can add a slicer to your visualization with that column, if you will select the 0 in the slicer all the names that have both (MRB and not MRB) will disappear from the page

Microsoft
Microsoft

Hi @bhmiller89,

Have you resolved your issue? If you have, welcome to share your own solution or mark the right reply as answer. More people will get useful information from here.

Thanks,
Angelia

No resolution to my issue yet

Microsoft
Microsoft

Hi @bhmiller89,

If your issue still hasn't resolved, please create sample table(you can create fake data as your data is priavte) and list expected result, so that we can share solution which is close to your requirement.

Best Regards,
Angelia

Resolver IV
Resolver IV

Hi @bhmiller89,

 

First i want to know the whether all the values you are trying are in one table or in multiple tables.

 

But, my idea is to add the column which clasifies a JOB as "MRB" or "NOT MRB" in the visual filter(if you want to show in particular visual) or page filter(if you want to show in whole page level) and click on check box which have MRB JOBS in the filter. 

 

filters.PNG

 

Hope this helped you. Please give a kudo and accept solution if it worked for you.

@mehaboob557

 

I need to classify the Organization as MRB or NotMRB and each organization name has multiple jobs, some of which are MRB and some of whcih are Not MRB.

 

So for example I can have ClientX that has job 1 which is MRB and job 2 which is Not MRB but I need to tell BI that ClientX is an MRB client because at least one job is MRB.  

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors