Forum Discussion

Gerald23's avatar
Gerald23
Icon for Helper I rankHelper I
4 years ago
Solved

Count value and filter by other column

Hi Everyone,   I have a table that looks like this:   Order Date Order Number Customer Number Article Number Qualtity Ordered Sold Price NP SoldPrice-NP (This is a calculated Column) ...
  • Gerald23's avatar
    Gerald23
    4 years ago

    That was easier then I expected xD

     

    I used the code below to achieve this

     

    Count all article below 0 = CALCULATE(SUM(Data[Quantity Ordered]), Data[SoldPrice-NP] < 0)
Gerald23's avatar
Gerald23
Icon for Helper I rankHelper I
4 years ago

That was easier then I expected xD

 

I used the code below to achieve this

 

Count all article below 0 = CALCULATE(SUM(Data[Quantity Ordered]), Data[SoldPrice-NP] < 0)