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:
Lakehouse table error : Encountered Azure error wh...
-
v-xiaoyan-msft
on:
Connect Partitioned table in Fabric Lakehouse to P...
-
v-xiaoyan-msft
on:
Issue: unable to load word cloud
- tolsond on: Power Bi Mark as Date Table issue after November 2...
-
v-pbandela-msft
on:
Can't refesh Data in PBI
-
v-xiaoyan-msft
on:
Access to ADO ODATA Feed from PowerBI is fails fro...
-
v-xiaoyan-msft
on:
Unable to export data from visuals that contain vi...
-
v-xiaoyan-msft
on:
Select All Slicer Option Sucks
-
v-xiaoyan-msft
on:
Absence of Create icon in parameter section
-
v-xiaoyan-msft
on:
how do i disable download for a specific PBI works...
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