angel585858
New Member
- Joined
- Jun 18, 2020
- Messages
- 5
- Office Version
- 2013
- Platform
- Windows
I have a power BI Dashboard that drills down by organization and I have 2 DAX Measures that I need to change based on Organization.
I was able to set a filter on the count measure but I can't get the Sum measure to filter. Can you tell me what I am doing wrong?
YTD PVA Target = CALCULATE (
SUM(
Budget[PVA Budget]
)/12*MONTH(
TODAY()
)
)
YTD PVA Count = CALCULATE (
COUNTROWS (AWAIR),
FILTER (
AWAIR,
AWAIR[MEHC Type] = "PVA"
)
)
I was able to set a filter on the count measure but I can't get the Sum measure to filter. Can you tell me what I am doing wrong?
YTD PVA Target = CALCULATE (
SUM(
Budget[PVA Budget]
)/12*MONTH(
TODAY()
)
)
YTD PVA Count = CALCULATE (
COUNTROWS (AWAIR),
FILTER (
AWAIR,
AWAIR[MEHC Type] = "PVA"
)
)