countrows

  1. S

    DAX Countrow Filter Userelationship not working together

    Does anyone know why the DAX below is not working? Do I have it in the wrong order? BTS Actual = CALCULATE(COUNTROWS('Schedule','Schedule'[Actual Count]), FILTER('Schedule','Schedule'[WO Type]="BTS") USERELATIONSHIP('Calendar'[Date],'Schedule'[Actual date performed])) Power BI just keeps...
    • SarahOrtega
    • Thread
    • countrows dax filter power bi usereleationship
    • Replies: 2
    • Forum: Power Tools
  2. D

    PowerPivot: "COUNTIF" for same row, same table?

    Good day, I thought this would be easy but I'm having a devil of a time, I hope someone can please help! I've tried writing this in a table; within PowerPivot; and as a measure but nothing seems to elicit what I'm after. (I'm new to PowerPivot, so I may be overlooking something obvious.) I'm...
    • DerekK
    • Thread
    • column countrows excel powerpivot region
    • Replies: 6
    • Forum: Power Tools
  3. S

    Average a Measure Over Time

    I'm using this measure =COUNTROWS(DISTINCT(COLUMN)) to tell me the number of unique items completed per person in a pivot table. I've done some searching, but I can't figure out how, in the table, to get an average of those unique items over time (weeks, months). The table data does include the...
    • slow1911s
    • Thread
    • average countrows distinct values powerpivot
    • Replies: 1
    • Forum: Power Tools

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top