Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculating daily difference on network throughput

Hi all,   We're using Power BI for something different than what it normally is used for - network analysis. The principle of course stay the same.   My issue is that I have multiple countries, w...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi amitchandak lbendlin , 

 

Thank you for your feedback. I've tested all the date formulas (which is super cool btw), but I'm getting stuck everytime on the same issue - whenever I'm trying to manipulate the throughput based on date, I'm getting an error back stating that: "a singe value for column 'throughput' in table 'network' cannot be determined." And then it continues about suggestions as to aggregating the data to get to a single result.

 

But, I already have a single result - per server which belongs to a specific region in a specific country I have 1 value per day.

 

What am I missing then? 

lbendlin's avatar
lbendlin
Super User
5 years ago

you're missing the concept of a filter context.  Just because you see a single value (date) on a visual  doesn't mean there is actually physically a single row of the extended table behind it.

 

So go with the aggregations (sum, average,whatever it appropriate) and use these aggregations as your formula input.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    lbendlin , can you perhaps provide me an example? 

     

    Whenever I try to use filters, I end up having to apply filtering to the point where I can only filter a single server (from the list I provided), instead of Power BI automatically picking the unique server and its throughput, and comparing it with another day.

    • lbendlin's avatar
      lbendlin
      Super User
      5 years ago

      here are a couple of examples based on your sample data.  What is your expected outcome?

       

       

      Sum:

      Average:

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thanks for your help so far lbendlin !

         

        Ok, so in the data set I provided, this data is collected every day, in total almost a year where every server's throughput is collected every day. I'm trying to perform a calculation whereby I'm doing a "today is x% more / less than yesterday" and a "this week is x% more / less than last week", and this quarter is x% more / less than last quarter", and so on. At the end of a week / month / quarter I can then generate a report over the different time frames and see if there was a negative growth or a positive growth in network throughput.

         

        And this is where I'm getting stuck - doing the calculation to determine the percentage growth over the different periods