Forum Discussion
Display duplicate
Hi baronraghu,
Based on my assumption, the formula of [total bids] should be:
total bids = CALCULATE(COUNT(bidder1[Buyers]),ALLEXCEPT(bidder1,bidder1[Product]))
Then, create an extra measure like this, add [check1] to table visual and set its value to 1.
check1 = IF([total bids]='Top N'[Top N Value],1,0)
Best regards,
Yuliana Gu
Hi baronraghu,
Please refer to this document to better understand ALLEXCEPT() function.
It is not possible to avoid duplicating values in table visual to get above result. As a workaround, you can use a Matrix instead.
Add [Product] and [Buyer] into "Rows" section of Matrix. Click the third "Drill Down" icon. Turn off "Stepped Layout" option.
Best regards,
Yuliana Gu
Hi baronraghu,
Based on my assumption, the formula of [total bids] should be:
total bids = CALCULATE(COUNT(bidder1[Buyers]),ALLEXCEPT(bidder1,bidder1[Product]))
Then, create an extra measure like this, add [check1] to table visual and set its value to 1.
check1 = IF([total bids]='Top N'[Top N Value],1,0)
Best regards,
Yuliana Gu
Thanks Yulina (@v-yulgu-msft)
The solution offered worked great. Just didnt understand the purpose of ALLEXCEPT in the formula.
Also is it possible to have a Product name not repeated in the table for multiple buyers. Illustration below
Product Buyer
A X
A M
A T
A P
A L
A E
I want to show my Data as
Product Buyer
A X
M
T
P
L
E
This way i feel it looks clean to see. Also I am open to any better visual/ recomendation
Thanks
Raghu
Hi baronraghu,
Please refer to this document to better understand ALLEXCEPT() function.
It is not possible to avoid duplicating values in table visual to get above result. As a workaround, you can use a Matrix instead.
Add [Product] and [Buyer] into "Rows" section of Matrix. Click the third "Drill Down" icon. Turn off "Stepped Layout" option.
Best regards,
Yuliana Gu