Forum Discussion

bryan_d's avatar
bryan_d
Regular Visitor
10 years ago
Solved

Help with counting

Hi there   I can't seem to get this to work - hoping you can help!   I have the following columns in a large table extracted from print logs:   DateGenerated     Time     Hour     Environment ...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    bryan_d 

     

    Here's the example I created

     

    The result looks like this

     

    Here are the Measures I used

    LEGACY # = COUNTROWS(FILTER(Table1, Table1[Environment]="LEGACY"))
LEGACY % = DIVIDE([LEGACY #], [TOTAL #], 0)
NEW # = COUNTROWS(FILTER(Table1, Table1[Environment]="NEW"))
NEW % = DIVIDE([NEW #],[TOTAL #],0)
TOTAL # = [LEGACY #] + [NEW #]

     

    Hope this helps!

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi bryan_d,

 

   you can use the COUNTA() function.

I'm sorry MattAllington I tried with the DISTINCTCOUNT() function, but I simply got 2 referred to the two different environments (as you can see from the screenshot).

 

Let Me Know If It Works.

 

#I'M Not An Expert#