The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Solved! Go to Solution.
SELECTEDVALUE returns the value when there’s only one value in the specified column, otherwise returns the alternate result. Here BLANK is returned. You may use MAX instead.
that worked like a charm . Thank you so much for taking the time to help me with this!
SELECTEDVALUE returns the value when there’s only one value in the specified column, otherwise returns the alternate result. Here BLANK is returned. You may use MAX instead.
that worked like a charm . Thank you so much for taking the time to help me with this!
BTW: Here's a couple of screenshots showing what I meant
as you can see it shows Scheduled Sales when slicing by days
Not showing any values or agregations when slicing by Months (FYFM in this case)