Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create Table with distinct values and count them

Hello, I've started working with Power BI desktop, and trying to count how many items I have in a period(it's dynamic) This is my source table product A: Serial# Manufacturing  date Sale Date...
Need Help
Tips and Tricks
  • johnt75's avatar
    johnt75
    4 years ago

    Create an inactive relationship from your Date table to the Sale Date column and then you can use USERELATIONSHIP, like

    Num sales = CALCULATE( COUNTROWS('Table'), USERELATIONSHIP( 'Date'[Date], 'Table'[Sale date]))
johnt75's avatar
johnt75
Super User
4 years ago

Create a proper Date table, and link the Date column to the Sale Date column in your current table. You can then use columns from the Date table in any visuals and create a measure like COUNTROWS('Products')

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks johnt75, I've created a proper calendar table, and already have a relationship with my product A table (to the manufacturing date), and whenever I try to work with standard measures it doesn't count the relevant rows.

i'm trying to get to some sort of a formula similar to count if Date=Sale Date   

  • johnt75's avatar
    johnt75
    Super User
    4 years ago

    Create an inactive relationship from your Date table to the Sale Date column and then you can use USERELATIONSHIP, like

    Num sales = CALCULATE( COUNTROWS('Table'), USERELATIONSHIP( 'Date'[Date], 'Table'[Sale date]))