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!

Sean's avatar
Sean
Community Champion
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!

MattAllington's avatar
MattAllington
Community Champion
10 years ago

Sorry, yes distinct count only works if you have a unique row identifer.  Your countrows formula are the best for your data.