Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
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
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.
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.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |