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

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 ?