Forum Discussion

austinjgreer's avatar
austinjgreer
Frequent Visitor
4 years ago

Division with a Filter

Hello,   I'm trying to divide using the count of values in one column, by the count of values in another column within a different table.  What I had originally was: Scan Rate = DIVIDE (COUNT (Tab...
Need Help
johnt75's avatar
johnt75
Super User
4 years ago

Is the column going on the table with the IP addresses or the hostnames. And do both tables have a month column?

austinjgreer's avatar
austinjgreer
Frequent Visitor
4 years ago

The column is going into Table 1. Table 2 is a static list of ~6500 IPs/hostnames that does not change and has no dates on it.

  • johnt75's avatar
    johnt75
    Super User
    4 years ago

    try

    Percentage = DIVIDE( CALCULATE( COUNTROWS('Table1'), 
ALLEXCEPT( 'Table1', 'Table1'[IP Address], 'Table1[Month]) ), COUNTROWS('Table2') )
    • austinjgreer's avatar
      austinjgreer
      Frequent Visitor
      4 years ago

      Tried it, and now I'm getting .02% for all rows. 

      • johnt75's avatar
        johnt75
        Super User
        4 years ago

        can you provide a sample PBIX ?