Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
I have a measure similar to the below (context changed)
However it doesn't work, it just returns all rows of the table by the selectedvalue[ReceivedDate] still.
I need it to create a linegraph showing
line A: the total number of 'sausages' received in a period
line B: the total number of 'sausages' 'reallyratherbadlyburnt' in a period
Dead Sausages (Use Received Date as Cooked Date) =
VAR SelectedFromDttm =
SELECTEDVALUE ( 'DD Log'[Received Date] )
RETURN
CALCULATE (
COUNTROWS ( 'DD Log' ),
FILTER ( ALL ( 'DD Log'[ReceivedDate] ), 'DD Log'[CookedDate] = SelectedFromDttm ),
'DD Log'[SausageStatus] = "reallyratherbadlyburnt"
)
Also Tried
Dead Sausages (Use Received Date as Cooked Date) =
VAR SelectedFromDttm =
SELECTEDVALUE ( 'DD Log'[Received Date] )
RETURN
CALCULATE (
COUNTROWS ( 'DD Log' ),
FILTER ( ALL ( 'DD Log'[CookedDate] ), 'DD Log'[CookedDate] = SelectedFromDttm ),
'DD Log'[SausageStatus] = "reallyratherbadlyburnt"
)
and
Dead Sausages (Use Received Date as Cooked Date) =
VAR SelectedFromDttm =
SELECTEDVALUE ( 'DD Log'[Received Date] )
RETURN
CALCULATE (
COUNTROWS ( 'DD Log' ),
FILTER ( ALL ( 'DD Log'), 'DD Log'[CookedDate] = SelectedFromDttm ),
'DD Log'[SausageStatus] = "reallyratherbadlyburnt"
)
Same results.
Please help.
Hi,
This should work.
Measure = COUNTROWS ( 'DD Log' )
Hope this helps.
Might be easier to help if you could provide sample data and show the expected result.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!