Forum Discussion

Anonymous

Not applicable

7 years ago

Multiple Value was supplied where single values was expected

Hi all, I try to show my acterys matrix light table like this My measure is like this Portfolio Summary = VAR CURRENTYEARMNAGEDSITES = CALCULATE([Total Managed Sites],FILTER(...

Need Help

TeigeGao

Solution Sage

7 years ago

Hi Anonymous ,

VALUES('Portfolio Summary'[DisplayMeasures])="Managed Sites"&&
VALUES('Portfolio Summary'[DisplayDimensions])="CurrentYear"

The function Values() returns a one-column table that contains the distinct values from the specified table or column, while you are using the = "Managed Sites", as a result, you will get the error message.

Best Regards,

Teige