Data Analysis

[gusdahu]

Power BI Community,

I have a data set composed of the following fields:

1. Vendors
2. Business Units (BU)
3. Amount of Spend per vendor/BU

The data set is currently in excel (nothing special). How may I isolate those vendors which are solely used by a particular BU?

Regards,

Gus Dahu 

[v-chuncz-msft]

@gusdahu ,

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/DAX-to-count-rows-with-same-value-for-Column-A-for-a-value-...

[gusdahu]

Unfortunately this is not what I am looking for.