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 Team
I have a table with customer name, Month like 2018 07-Jul,Order id. Suppose I select Months as May, June and July(in the mentioned format 2018 07-Jul), I only want to show those customer name who have a order for all the selected months. Suppose customer Alex has order id's for May,June and July then show Alex and John has order in June and July then don't show John.
try putting this measure in the visual filter while filtering to TRUE
Measure = VAR SelectedPeriods = ALLSELECTED ( 'Table'[Month] ) VAR PeriodsPerCustomer = SUMMARIZE ( 'Table', 'Table'[Month], 'Table'[Customer] ) RETURN IF ( COUNTROWS ( SelectedPeriods ) = COUNTX (PeriodsPerCustomer, [Month] ), TRUE, FALSE )
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |