cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Power_BI_Adapt
Resolver I
Resolver I

New measure for total number of lines

Dear All,

 

I seeking for support for the following:

 

I have beneath table:

Power_BI_Adapt_0-1658924535076.png

 

I want to build a measure as mentioned in red. This measure should give the number of records / lines of a specific month. Records with Jan data have three entries, in Feb 2 entries and March 4 entries. These numbers should return in a measure. 

 

Any suggestion is welcome. Thanks!

 

Kind regards,

1 ACCEPTED SOLUTION
serapinasnovian
Frequent Visitor

Hello,

 

Please try the following:

 

CALCULATE(COUNT('Table'[Sales]),ALLEXCEPT('Table','Table'[Month]))

View solution in original post

1 REPLY 1
serapinasnovian
Frequent Visitor

Hello,

 

Please try the following:

 

CALCULATE(COUNT('Table'[Sales]),ALLEXCEPT('Table','Table'[Month]))

Helpful resources

Announcements
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors