Forum Discussion

Anonymous's avatar
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('fact_site_agreement',fact_site_agreement[Effective RFAI Date].[Year] = [2-TY PS]))
VAR PREVIOUSYEARMANAGEDSITES =
CALCULATE([Total Managed Sites],FILTER('fact_site_agreement',fact_site_agreement[Effective RFAI Date].[Year] = [1-LY PS]))
VAR CURRENTMONTHMANAGEDSITES =
CALCULATE([Total Managed Sites],FILTER('fact_site_agreement',fact_site_agreement[Effective RFAI Date].[MonthNo]=[1-MTD PS]))
VAR PREVIOUSMONTHMANAGEDSITES =
CALCULATE([Total Managed Sites],FILTER('fact_site_agreement','fact_site_agreement'[Effective RFAI Date].[MonthNo]=[2- MLD PS]))
VAR CURRENTQUARTERMANAGEDSITES =
CALCULATE([Total Managed Sites],FILTER('fact_site_agreement','fact_site_agreement'[Effective RFAI Date].[QuarterNo]=[1-QTD PS]))
VAR PREVIOUSQUARTERMANAGEDSITES =
CALCULATE([Total Managed Sites],FILTER('fact_site_agreement','fact_site_agreement'[Effective RFAI Date].[QuarterNo]= [2 - QLD PS]))
VAR QUARTERVARIANCEMANAGEDSITES =
DIVIDE(CURRENTQUARTERMANAGEDSITES,PREVIOUSQUARTERMANAGEDSITES)*100
VAR MONTHVARIANCEMANAGEDSITES =
DIVIDE(CURRENTMONTHMANAGEDSITES,PREVIOUSMONTHMANAGEDSITES)*100
VAR YEARVARIANCEMANAGEDSITES =
DIVIDE(CURRENTYEARMNAGEDSITES,PREVIOUSYEARMANAGEDSITES)*100



VAR CURRENTYEARTOWER =
CALCULATE([Total Owned Sites],FILTER('fact_site_agreement','fact_site_agreement'[Effective RFAI Date].[Year] = [2-TY PS]))
VAR PREVIOUSYEARTOWER =
CALCULATE([Total Owned Sites],FILTER('fact_site_agreement',fact_site_agreement[Effective RFAI Date].[Year] = [1-LY PS]))
VAR CURRENTMONTHTOWER =
CALCULATE([Total Owned Sites],FILTER('fact_site_agreement','fact_site_agreement'[Effective RFAI Date].[MonthNo] =[1-MTD PS]))
VAR PREVIOUSMONTHTOWER =
CALCULATE([Total Owned Sites],FILTER('fact_site_agreement','fact_site_agreement'[Effective RFAI Date].[MonthNo]= [2- MLD PS]))
VAR CURRENTQUARTERTOWER =
CALCULATE([Total Owned Sites],FILTER('fact_site_agreement','fact_site_agreement'[Effective RFAI Date].[QuarterNo]=[1-QTD PS]))
VAR PREVIOUSQUARTERTOWER =
CALCULATE([Total Owned Sites],FILTER('fact_site_agreement','fact_site_agreement'[Effective RFAI Date].[QuarterNo]= [2 - QLD PS]))
VAR QUARTERVARIANCETOWER =
DIVIDE(CURRENTQUARTERTOWER,PREVIOUSQUARTERTOWER)
VAR MONTHVARIANCETOWER =
DIVIDE(CURRENTMONTHTOWER,PREVIOUSMONTHTOWER)
VAR YEARVARIANCETOWER =
DIVIDE(CURRENTYEARTOWER,PREVIOUSYEARTOWER)



VAR CURRENTYEARTENANCIES =
CALCULATE([Total owned sites Tenancy],FILTER('fact_site_agreement','fact_site_agreement'[Effective RFAI Date].[Year] = [2-TY PS]))
VAR PREVIOUSYEARTENANCIES =
CALCULATE([Total owned sites Tenancy],FILTER('fact_site_agreement','fact_site_agreement'[Effective RFAI Date].[Year] = [1-LY PS]))
VAR CURRENTMONTHTENANCIES =
CALCULATE([Total owned sites Tenancy],FILTER('fact_site_agreement','fact_site_agreement'[Effective RFAI Date].[MonthNo] =[1-MTD PS]))
VAR PREVIOUSMONTHTENANCIES =
CALCULATE([Total owned sites Tenancy],FILTER('fact_site_agreement','fact_site_agreement'[Effective RFAI Date].[MonthNo]= [2- MLD PS]))
VAR CURRENTQUARTERTENANCIES =
CALCULATE([Total owned sites Tenancy],FILTER('fact_site_agreement','fact_site_agreement'[Effective RFAI Date].[QuarterNo]=[1-QTD PS]))
VAR PREVIOUSQUARTERTENANCIES=
CALCULATE([Total owned sites Tenancy],FILTER('fact_site_agreement','fact_site_agreement'[Effective RFAI Date].[QuarterNo]=[2 - QLD PS]))
VAR MONTHETENANCIESVARIANCE =
DIVIDE(CURRENTMONTHTENANCIES,PREVIOUSMONTHTENANCIES)*100
VAR YEARTENANCIESVARIANCE =
DIVIDE(CURRENTYEARTENANCIES,PREVIOUSYEARTENANCIES)*100
VAR QUARTERTENANCIESVARIANCE =
DIVIDE(CURRENTQUARTERTENANCIES,PREVIOUSQUARTERTENANCIES)*100


VAR DISPLAY =
SWITCh(TRUE(),
VALUES('Portfolio Summary'[DisplayMeasures])="Managed Sites"&&
VALUES('Portfolio Summary'[DisplayDimensions])="CurrentYear",CURRENTYEARMNAGEDSITES,
VALUES('Portfolio Summary'[DisplayMeasures])="Managed Sites"&&
VALUES('Portfolio Summary'[DisplayDimensions])="PreviousYear",PREVIOUSYEARMANAGEDSITES,

VALUES('Portfolio Summary'[DisplayMeasures])="Towers"&&
VALUES('Portfolio Summary'[DisplayDimensions])="CurrentYear",CURRENTYEARTOWER,
VALUES('Portfolio Summary'[DisplayMeasures])="Towers"&&
VALUES('Portfolio Summary'[DisplayDimensions])="PreviousYear",PREVIOUSYEARTOWER,

VALUES('Portfolio Summary'[DisplayMeasures])="Tenancies"&&
VALUES('Portfolio Summary'[DisplayDimensions])="CurrentYear",CURRENTYEARTENANCIES,
VALUES('Portfolio Summary'[DisplayMeasures])="Tenancies"&&
VALUES('Portfolio Summary'[DisplayDimensions])="PreviousYear",PREVIOUSYEARTENANCIES,


BLANK())

RETURN DISPLAY

 

However, I got this error. Is anyone familiar with this error? I can't find any solution to this problem yet. Hopefully, someone can help with this. 

Need Help

1 Reply

  • TeigeGao's avatar
    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