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!

bryan_d's avatar
bryan_d
Regular Visitor
10 years ago

That's great Sean - thanks so much!

 

Quick question - just wondering if you manually created the entries in the 'DateGenerated' & 'Hour' columns, or were these automatically populated?

 

Thanks

 

Bryan

  • Sean's avatar
    Sean
    Community Champion
    10 years ago

    bryan_d DateGenerated and Time yes manually I just created a small table to show you the result - Hour derived from time

     

    Anyway the problem with the above formula suggested although it works in a Matrix - it has more limited use

     

    How are you going to display just the Legacy # with a Card? (not multi-row card)

     

    Can you create a Line and Clusted Column Chart?