Forum Discussion

venug's avatar
venug
Icon for Helper II rankHelper II
6 years ago

DAX - Max Month Store wise Calculations

Hi Everyone,   i have table like below, when i going to calculate store wise sum. when select month in slicer that month take store type and define corrsponding values.    like when i select mont...
Need Help
venug's avatar
venug
Icon for Helper II rankHelper II
6 years ago

amitchandak  Thanks for respond,

 

when i select month in slicer, the store type is different from other months, so that reason i unble to use concatenate.

 

i am usinig below formula ...

 

VAR monthselection = SELECTEDVALUE(Sheet1[Month N])
VAR StoreValue = SUMX(FILTER(ALL(Sheet1), Sheet1[Month N]= monthselection && Sheet1[Store type] = "Retain" && Sheet1[Store] = "T" || Sheet1[Store] = "T" ), Sheet1[Sale])
Return
StoreValue

 

here i am unble to pass stores dynamically.

 

Please hep on this , thanks in advance..

 

Regards

Venu

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      6 years ago

      In case you want all the store names of a type. You can choose All(table[Month])  to remove the month filter.

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        6 years ago

        I tried, This does give me  C L N T with March filter for R

        CALCULATE(CONCATENATEX(FILTER(DISTINCT(concatData),concatData[Store type]="R"),(concatData[Store])," "))