Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
darkmetrics
Helper I
Helper I

Why the measure returns error "A table of multiple values was supplied where a single value..."?

Good afternoon!
I have a measure which calculates sales MTD, QTD or YTD and depends on slicer SalesDateSlicer value:

MyMeasure :=

var Result =
SWITCH
(
    SELECTEDVALUE(SalesDateSlicer[Period]),
    "MTD", CALCULATE(SUM('Sales'[Sales]), 
                     FILTER(ALL('Sales'),
                            DATESMTD('Sales'[Date]))
           ), 
    "QTD", CALCULATE(SUM('Sales'[Sales]), 
                     FILTER(ALL('Sales'),
                            DATESQTD('Sales'[Date]))
                    ),                         
    "YTD", CALCULATE(SUM('Sales'[Sales]), 
                     FILTER(ALL('Sales'),
                            DATESYTD('Sales'[Date]))
    )
)

RETURN Result 

 However, when I try to use my measure in a matrix it fails with error "A table of multiple values was supplied where a single value was expected". How to fix that?

1 REPLY 1
tamerj1
Super User
Super User

Hi @darkmetrics 
Please try

MyMeasure :=
VAR Result =
    SWITCH (
        SELECTEDVALUE ( SalesDateSlicer[Period] ),
        "MTD",
            CALCULATE (
                SUM ( 'Sales'[Sales] ),
                DATESMTD ( 'Sales'[Date] ),
                ALL ( 'Sales' )
            ),
        "QTD",
            CALCULATE (
                SUM ( 'Sales'[Sales] ),
                DATESQTD ( 'Sales'[Date] ),
                ALL ( 'Sales' )
            ),
        "YTD",
            CALCULATE (
                SUM ( 'Sales'[Sales] ),
                DATESYTD ( 'Sales'[Date] ),
                ALL ( 'Sales' )
            )
    )
RETURN
    Result

However, this is not guaranteed to work as time intelligence functions require standard date table with homogeneous date column. It is always a good idea to use a dimension date table.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.