Calculate only if value available in column

[Anonymous]

Hi All,

In my table i have columns like 1.Quantiy, 2. Price, 3. Payment Date. For some values of price, i dont have payment Dates. Now, i want to calculate Total sales=[Quantity]*[Price], only for available Payment Dates and exclude when payment date value is not available for that particular price column value. Do anyone have idea on how to do this?

Looking for sooner solution.

TIA

[v-alq-msft]

Hi, @Anonymous 

Based on your description, I create data to reproduce your scenario.

Table:

Then you may create a measure as follows.

Total Sales = 

SUMX(
        FILTER(
            'Table',
            'Table'[Payment Date]<>BLANK()
        ),
        'Table'[Quantity]*'Table'[Price]
)

Result:

Best Regards

Allan

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

[amitchandak]

Try

//new Measure
sumx(filter(table,not(isblank(table[price])),table[Quantity]*table[Price])
Or
calculate(sumx(table,table[Quantity]*table[Price]),not(isblank(table[price])))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Anonymous]

If(isblank(table[date])=TRUE,0,table[quntity]*table[price])


Thanks,
Pravin

If it resolves your problem mark it as a solution.