Forum Discussion

chrisread9907's avatar
chrisread9907
Frequent Visitor
10 years ago

SUMIF and VLOOKUP within BI

Hi,   I'm new to power Bi and trying to manipulate some data from my SQL database.   This is a screenshot of the data tables im trying to work on:     What i am looking to do is do a SUM...
Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

chrisread9907

You can try this as well.

 

Measure = 
CALCULATE (
    SUM ( YourTable[DurationSeconds] ),
    FILTER (
        YourTable,
        YourTable[slaveId] = 1
            && INT(YourTable[dateEnd]) = INT(TODAY ())
            && YourTable[channel1] = 1
            && YourTable[error] = FALSE ()
    )
)
  • chrisread9907's avatar
    chrisread9907
    Frequent Visitor
    10 years ago

    This is spot on, give the figure i need, Thanks.

     

    Can I create another measure to perfom a calculation on this mease?

    • Eric_Zhang's avatar
      Eric_Zhang
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

      chrisread9907

      chrisread9907 wrote:

      This is spot on, give the figure i need, Thanks.

       

      Can I create another measure to perfom a calculation on this mease?

       

      Surely you can. What is the problem when use it in anothere measure?