Forum Discussion

MP275's avatar
MP275
Frequent Visitor
2 years ago
Solved

Hi All,

I am struggling to get the below solved using dax, could someone help plss   We have date and time dimensions with sales for every 15 minute intervals. I have a measure for sum of sales, I would li...
Need Help
  • DataInsights's avatar
    DataInsights
    2 years ago

    MP275,

     

    Try a measure like this:

     

    Count Sales Over 40k =
VAR vSalesByDateAndArea =
    ADDCOLUMNS (
        SUMMARIZE ( FactTable, FactTable[Date], FactTable[Area] ),
        "@Sales", [Sum of Sales]
    )
VAR vResult =
    COUNTROWS ( FILTER ( vSalesByDateAndArea, [@Sales] > 40000 ) )
RETURN
    vResult
MP275's avatar
MP275
Frequent Visitor
2 years ago

Hi DataInsights, I have unioined the both fact table rows and getting the desired results. 

Thank you so much for the help