Forum Discussion

JavierCanelon's avatar
JavierCanelon
Frequent Visitor
5 years ago
Solved

Isues with a performance supplier report

Hi everyone, We want to create a visual to show us a report for a supplier and competitors he is losing against in tenders where he participate (the suppliers do not participate in all tenders), for...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi JavierCanelon ,

    According to my understand, you want to know the number of successful bids for each competitor in all projects that Provider1 participated in, right?

    You could create a calculated table simplely using the following formula:

    newTable =
VAR _tt =
    SUMMARIZE (
        FILTER ( ALL ( 'Table' ), [Provider] = "Provider1" ),
        'Table'[Request Item]
    )
RETURN
    FILTER ( 'Table', [Request Item] IN _tt && [Status] = "Adjudicated" )

     

    Here is the pbix file.

     

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please upload some insensitive data samples and expected output.

     

    Best Regards,
    Eyelyn Qin

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi JavierCanelon ,

According to my understand, you want to know the number of successful bids for each competitor in all projects that Provider1 participated in, right?

You could create a calculated table simplely using the following formula:

newTable =
VAR _tt =
    SUMMARIZE (
        FILTER ( ALL ( 'Table' ), [Provider] = "Provider1" ),
        'Table'[Request Item]
    )
RETURN
    FILTER ( 'Table', [Request Item] IN _tt && [Status] = "Adjudicated" )

 

Here is the pbix file.

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

 

Best Regards,
Eyelyn Qin

  • JavierCanelon's avatar
    JavierCanelon
    Frequent Visitor
    5 years ago

    Hi Anonymous, sorry for my late reply, I am very grateful for your solution, however it is required to be able to select the evaluated provider not just Provider1. On the other hand, it would be very useful to know if the selected supplier was awarded for having the lowest price or not. I will be really grateful for your help.

    Thanks in advance.

    Javier Canelón