Forum Discussion
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...
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]))
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
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]))