How to create a measure to display values based on conditions on period of time

[lovedata]

Hi Power BIgurus, I have a very strange scenario I want to visualize in Power BI. I am not sure how I can achieve it and your help would be really appreciated here.

What I am trying to achieve is that I want to calculate weighted price (Volume*Price) for multiple vendors over time. However, this condition is only applicable if there are no multiple contracts with the same vendors or multiple vendors over the same period of time. In that case, we only need to display the price only, without multiplying it by its Volume, as it is already weighted by the customer.  I tried to illustrate my goal with a hand sketch above. W = volume and P is price. So I want to multiply the column by the price If there is no other contract for the given period of time and just the price if there is another contract for the given period of time. How can I achieve this in DAX, please?

Please beware that both fields come from the same table. The field's names are W for volume and P is for the price, let's assume. 

[v-chenwuz-msft]

Hi @lovedata ,

Please share some sample data or screenshot without sensitive data and expect result. I apologise as I am not entirely understanding "display the price only, without multiplying it by its Volume", is that your volume is %?

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Or this expression you can try.

measure =
VAR _s =
    SUMMARIZE (
        'table',
        [vendors],
        [W],
        [P],
        "%", DIVIDE ( [W], CALCULATE ( SUM ( [W] ), ALLSELECTED ( 'table'[vendors] ) ) )
    )
RETURN
    SUMX ( _s, [%] * [P] )

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.