DAX Commands and Tips

Join the discussion


create measures with filters by Marango on ‎12-18-2024 09:57 AM Latest post on ‎12-19-2024 09:06 PM by Anonymous 2 Replies 410 Views	2 Replies	410 Views
Measures using filters of negative and positive re... by Marango on ‎12-12-2024 02:16 PM Latest post on ‎12-12-2024 10:12 PM by Anonymous 2 Replies 358 Views	2 Replies	358 Views
DAX Getting Same Grand Total Amount in Each Row by BrianNeedsHelp on ‎11-16-2024 02:05 PM Latest post on ‎11-17-2024 09:42 AM by BrianNeedsHelp 4 Replies 426 Views	4 Replies	426 Views
I’m trying to calculate a specific type of what-if... by LightSQR on ‎05-07-2024 07:22 AM Latest post on ‎05-07-2024 07:50 PM by Anonymous 1 Reply 268 Views	1 Reply	268 Views
Blank Values when multiple filters are applied by ragnezza on ‎04-25-2024 02:59 PM Latest post on ‎04-26-2024 10:05 AM by ragnezza 2 Replies 628 Views	2 Replies	628 Views
Ignoring a field filter but still wanting to sort ... by 99_pct on ‎04-22-2024 07:25 AM Latest post on ‎04-26-2024 08:19 AM by 99_pct 5 Replies 559 Views	5 Replies	559 Views
Have calculations only work in the filtered contex... by Kalibur on ‎03-05-2024 01:49 PM Latest post on ‎03-06-2024 05:34 AM by Kalibur 2 Replies 456 Views	2 Replies	456 Views
Measure to Filter out Values Based on Current Time by victoryamaykin on ‎12-27-2023 12:08 PM Latest post on ‎12-28-2023 10:11 AM by victoryamaykin 4 Replies 600 Views	4 Replies	600 Views
Need Help with DAX for Multiple Columns with Multi... by Strongbuck on ‎12-01-2023 01:57 PM Latest post on ‎12-01-2023 02:25 PM by AlexisOlson 1 Reply 481 Views	1 Reply	481 Views
Multiple Filters from multiple tables with a VAR by kalkhudary on ‎09-26-2023 08:19 PM Latest post on ‎09-27-2023 06:35 AM by kalkhudary 4 Replies 552 Views	4 Replies	552 Views
Create a Calculated Column using MAX value from an... by AvalBuroAdmin on ‎09-03-2020 12:50 PM Latest post on ‎07-26-2023 04:58 AM by sunnyzags 5 Replies 2254 Views	5 Replies	2254 Views
Help with DAX for Scaled Score Matrix by NKumar on ‎06-08-2023 11:31 PM Latest post on ‎06-09-2023 03:11 AM by NKumar 2 Replies 486 Views	2 Replies	486 Views
Average revenue for product relative to the state ... by JMD22Si on ‎05-16-2023 09:23 AM Latest post on ‎05-17-2023 07:52 AM by JMD22Si 2 Replies 351 Views	2 Replies	351 Views
After adding column with totals without a specific... by Anonymous on ‎04-12-2023 02:40 PM Latest post on ‎04-13-2023 04:35 AM by Anonymous 2 Replies 431 Views	2 Replies	431 Views
Prevent filters from impacting a virtual table ins... by mark_carlisle on ‎03-06-2023 06:30 AM Latest post on ‎03-06-2023 08:55 PM by mark_carlisle 2 Replies 485 Views	2 Replies	485 Views
Implementing a TopN filter per category by BachDinh on ‎02-13-2023 12:48 PM Latest post on ‎02-14-2023 02:43 AM by tamerj1 5 Replies 1438 Views	5 Replies	1438 Views
Using DAX to hide entries in table if there are lo... by WillP on ‎01-21-2023 05:51 AM Latest post on ‎02-09-2023 04:38 AM by WillP 4 Replies 1091 Views	4 Replies	1091 Views
How do can I calculate months in a relative date f... by jimh153 on ‎02-08-2023 01:34 PM Latest post on ‎02-08-2023 02:36 PM by jimh153 2 Replies 541 Views	2 Replies	541 Views
Measure in value field to ignore the legend of cha... by Anonymous on ‎12-12-2022 01:10 PM Latest post on ‎12-13-2022 05:05 AM by Anonymous 2 Replies 1249 Views	2 Replies	1249 Views
Home Page in Power BI by theov on ‎11-28-2022 02:24 AM Latest post on ‎11-28-2022 03:19 AM by NikhilChenna 1 Reply 304 Views	1 Reply	304 Views
Total revenue of all sale persons but only for th... by li_pham on ‎11-13-2022 06:43 AM Latest post on ‎11-18-2022 01:27 AM by v-xiaotang 3 Replies 412 Views	3 Replies	412 Views
Count Rows based on a DATEDIFF Value greater than ... by jdickson on ‎11-10-2022 06:13 AM Latest post on ‎11-16-2022 01:27 AM by v-jialluo-msft 4 Replies 1866 Views	4 Replies	1866 Views
Filter per last entry, per month by Anonymous on ‎10-22-2022 05:11 PM Latest post on ‎10-23-2022 10:48 AM by daXtreme 4 Replies 742 Views	4 Replies	742 Views
Applying multiple filters on table (with the goal ... by MoeData on ‎10-06-2022 02:15 PM Latest post on ‎10-10-2022 03:12 AM by MoeData 2 Replies 882 Views	2 Replies	882 Views
Ensuring Dates are factored into your Dax Command by Karolina411 on ‎08-03-2022 10:33 AM Latest post on ‎08-07-2022 07:54 PM by v-yalanwu-msft 3 Replies 548 Views	3 Replies	548 Views
Selected Value Blank by Anonymous on ‎11-05-2019 03:39 AM Latest post on ‎08-02-2022 05:42 PM by jmweekes 3 Replies 2446 Views	3 Replies	2446 Views
DAX measure is ignoring / overriding filter on pag... by Anonymous on ‎06-15-2022 07:04 AM Latest post on ‎06-15-2022 08:25 AM by SpartaBI 3 Replies 543 Views	3 Replies	543 Views
How to keep filter on category but remove it on # ... by lava_ on ‎05-10-2022 03:12 PM Latest post on ‎05-31-2022 12:21 AM by v-cazheng-msft 3 Replies 1301 Views	3 Replies	1301 Views
Need help writing a DAX to count distinct values w... by Anonymous on ‎05-16-2022 08:20 AM Latest post on ‎05-19-2022 06:41 PM by v-kkf-msft 5 Replies 482 Views	5 Replies	482 Views
2 FILTERS by k1ko92 on ‎05-06-2022 05:43 AM Latest post on ‎05-09-2022 11:54 PM by Anonymous 2 Replies 580 Views	2 Replies	580 Views