The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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)
User | Count |
---|---|
78 | |
74 | |
42 | |
32 | |
28 |
User | Count |
---|---|
104 | |
93 | |
52 | |
50 | |
46 |