Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 )
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |