Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Show customer data for selected months

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 ...
Interesting Links
Need Help
Tips and Tricks
Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
8 years ago

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
    )
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Stachu GilbertQ

     

    I have used the DAX you mentioned as a measure instead of TRUE(), I have CALCULATE(COUNT(column),ALLSELECTED(MONTH)) so its working fine for selected 3 Months but its not showing the breakdown for the users for the 3 selected months.