I have a dataset with column MeetingYrQtr based in meeting date, RegionCode and YrQtrName based on another table with dates.
I want to change my dax PBWithMinsTQtrEXP to calculate total ProjsWithMins when MeetingYrQtr = YrQtrName that I selected from the slicer for example "2024 Q1" is the selected value in YrQtrName slicer it should display 12 as total
The display is wrong when i used this formula
PBWithMinsTQtrEXP = CALCULATE(SUM(PBMins[PrjsWithMins]),PBMins[MeetingYrQtr]= MAX(Dim_Date_ALL[YrQtrName]))
Comments
-
v-xiaoyan-msft
on:
Refresh dataflows from other users
-
v-xiaoyan-msft
on:
Help with a Error Message" An error occurred while...
- brianoliver20 on: Power BI Total Labels Only Show SOME of the Number...
-
v-xiaoyan-msft
on:
Unable to convert to Import
-
v-tianyich-msft
on:
Cross filtering in Power BI report not working cor...
-
v-tianyich-msft
on:
Conditional Formatting on KPI visual
-
v-tianyich-msft
on:
Embedding a DirectLake report is not supported
-
v-yetao1-msft
on:
Data Model Load Failed
-
DonalMc
on:
Something went wrong Token '=' expected
-
v-yetao1-msft
on:
Drag-select with mouse in DAX Formula Bar working ...
Hi @sjpbi ,
You can use var _select = selectedvalue(Dim_Date_ALL[YrQtrName])) to get the year you want, so your expression should change to PBMins[MeetingYrQtr]=_select
Best regards,
Community Support Team_ Scott Chang