Vipul Shah's SQL Blogs

SQL Server Blogs

May, 2013

  • How to apply Filter in Data Explorer Formula

    I ran into below particular scenario. My Sample Table:   Desired Output:   In PowerPivot DAX Formula, I could easily achieve this as this - Actual Formula: =[Market Value]/SUMX(FILTER(mySampleTable,mySampleTable[PlanName]="ABC"),mySampleTable...