Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a very simple measure that I've been stuck on.
I want to sum the $ amount of a table based on 3 conditions + remove the date slicer on the report page.
Relationship is the Date Table is linked to a PnL Data table by date. The Date table has a slicer.
Here's my measure:
CALCULATE(SUM(PnL[$]),
Solved! Go to Solution.
Thanks Pragati11.
I did try a modification of this function with mixed results. When using Filter(ALL(Date), then the only field that can be filtered is date.
Here's what I did, however some of my detail views didn't submit up everything properly at the detail level.
CALCULATE (SUM (PnL [$]),
Hi @Anonymous ,
I will suggest writing your dax as follows:
CALCULATE(SUM(PnL[$]),
Thanks Pragati11.
I did try a modification of this function with mixed results. When using Filter(ALL(Date), then the only field that can be filtered is date.
Here's what I did, however some of my detail views didn't submit up everything properly at the detail level.
CALCULATE (SUM (PnL [$]),
Hi @Anonymous
Try
CALCULATE (
SUM ( PnL[$] ),
FILTER (
PnL,
PnL[Type] = "Asset" && PnL[Class] <> "Overhead" && PnL[Sold?] = "False"
),
ALL ( PnL[Date] )
)
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Thanks A|B,
Unfortunately this doesn't work either. I even simplified the structure by removing the 'date table' and switched the date slicer from the 'date table' to the date field in the PnL data.
This is the result I get when I have ALL(PnL[Date])) - it still filters to only be 12/1/2020 data
Hi @Anonymous ,
Can you kindly share the exact syntax of your measure please ; in order to understand the exact error.?
Currently I can't understand it completly as you have split it into two.
Also, try sharing some sample data.
Thanks,
Pragati
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |