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:
Metric processing failed. Activity Id
-
v-xiaoyan-msft
on:
Issues updating SSL off-prem
- wemersontm on: Error on total column
-
v-yetao1-msft
on:
PowerBI Service - filter by keyword doens't bring ...
-
v-xiaoyan-msft
on:
Power BI Crashes When Using Quick Measure
-
v-yetao1-msft
on:
Cannot load model mod
-
christinepayton
on:
Issue with slicer search in PBI service
-
v-xiaoyan-msft
on:
Microsoft Fabric Trial Issue
-
v-yetao1-msft
on:
issues loading pbix
-
v-xiaoyan-msft
on:
The given key was not present in the dictionary.
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