Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Zanderol24
New Member

Same Value Multiple Columns

Hi, 

 

Im trying to construct a visual with the below scenario, 

 

I have a Dynamics Opportunity that features 3 columns with a relatioship to the Dynamics Competitor table, these are lookup columns. 

 

The lookup coulumn names on the opportunity could be 

 

Product1

Product2

Product3 

Product4, 

 

My goal within the visual is to count the values for each column per categort (product)

 

No matter how I do this the values are always the same across all bi visuals, im not sure how to get the data to calculate how many times an opportinity has had the lookup column on based on the competitor, all values aRE always identical, do i need to use a dax query or am i overlooking something simple

 

Zanderol24_0-1694795273289.pngZanderol24_1-1694795296905.png

 

2 REPLIES 2
chonchar
Helper V
Helper V

Try creating a measure and putting it into the values. Make one for each product:

Product one count =
DISTINCTCOUNT(
(Table name)[Product1]

^^ do the same for products 2-4 (four unique measures) then add them to the values pane. 

 

Good luck and hope this helps,

 

Cam

thanks will try, out of curiosity how does this differ from using the count distinct right click option on the field value?  Thanks again 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.