Forum Discussion

Vamshi2020's avatar
Vamshi2020
Helper II
5 years ago
Solved

Count rows except the selected date range

Hi guys,

 

I have Table A which has Arrival Date, Affliate columns and calender table which i use for Slicer. Iam using Between view of slicer.

My requirement is to get the count of Affliates after end range of slicer. For ex:

if i select 1st Oct to 19th oct in slicer , it should give me the count of rows after 19th oct .

 

I tried with below measure , unfortunately it's not working.

var a=MAXX(Calender,Calender[Date])
var b=CALCULATE(COUNTROWS('Data_Arrivals with Case Priorit'),'Data_Arrivals with Case Priorit'[Arrival Date]>=a)
return b
 
The measure just gives the value for default view, but not for slicer selection.

Please helpme on this.
 
TIA

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Vamshi2020 ,

     

    You may try this measure. There is no relationship between the calendar table and the main table.

    CountRows =
CALCULATE (
    COUNTROWS ( 'Table' ),
    FILTER ( 'Table', NOT ( [Arrival Date] IN ALLSELECTED ( 'Calendar'[Date] ) ) )
)

     

    You can check more details from here.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Vamshi2020 ,

     

    You may try this measure. There is no relationship between the calendar table and the main table.

    CountRows =
CALCULATE (
    COUNTROWS ( 'Table' ),
    FILTER ( 'Table', NOT ( [Arrival Date] IN ALLSELECTED ( 'Calendar'[Date] ) ) )
)

     

    You can check more details from here.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    5 years ago
    I haven't read too carefully, so I may be off mark here, but try:

    var a=MAXX(ALLSELECTED(Calender),Calender[Date])
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    Hi,

    Try this measure

    =calculate(COUNTROWS('Data_Arrivals with Case Priorit'),datesbetween(calendar[date],max(calendar[date])+1,maxx(all(calendar),calendar[date])))

    Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Vamshi2020 ,

    Could you tell me if your problem has been solved?
    If it is, kindly Accept it as the solution. More people will benefit from it.
    Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.


    Best Regards,
    Stephen Tao