Antriksh SharmaApr 9, 20217 min readHow To Exclude Slicer Selection from the result with DAX in Power BIOne of a very common requirement that I have seen is to be able to filter out the selection made in the slicer from a visual such as a...
Antriksh SharmaMar 21, 20211 min readDAX | CALCULATE | March’ 2021 UpdateEffective March update of Power BI you can specify different columns in the single filter argument of CALCULATE without writing the...
Antriksh SharmaMar 1, 20211 min readPower BI: Visualizing Filter contextIf there is one thing every DAX developer has ever dreamt about is to be able to view the filter context inside Power BI to debug DAX...
Antriksh SharmaFeb 23, 20212 min readThinking Behind Use of KEEPFILTERS in DAXIn this blog let’s understand why you should use KEEPFITLERS more often. Below is the snapshot of the data model ( Contoso Retail Data...
Antriksh SharmaJan 20, 20215 min readPower BI DAX: Context Transition - Behind the scenesContext transition — one of the most complex topics to understand and master but have you ever wondered, what actually happens behind the...
Antriksh SharmaNov 22, 20208 min readRunning Totals exclude days from the calculationCreating a Running Total is pretty simple in DAX, you just take a measure, wrap it inside CALCULATE and then with the help of DATESYTD...