Please Help !!! I have created a P&L in power BI. the problem is when i try to use the key value measure in a new matrix it returns an error. If i copy the visual it still works but not in a new one ??? the measure and the error it returns is below:

John Harrison 21 Reputation points

ERROR is : "A table of multiple values was supplied when a single value was expected"

I have the below in two separate matrix on the same dashboard. The new one returns the above error, and the original visual works perfect, filtering and all !!

I think the error refers to the " VALUES(ReportLayout[Line]) ="Total Revenue",Revenue "

The ReportLayout is the P&L format table.

Everything was working fine until i tried to Use the measure in a new matrix. Both matrix are set up exactly the same (filters etc). One works perfect the other nothing but the error. So frustrating!!!

PL Totals '000 =
VAR Revenue = CALCULATE(SUM(CONSOL[NetAbs]),ALLSELECTED(ReportLayout),ReportLayout[Section]="Revenue")
VAR OpCost = CALCULATE(SUM(CONSOL[NetAbs]),ALLSELECTED(ReportLayout),ReportLayout[Section]="Operating Cost")
VAR OpProfit = Revenue-OpCost
VAR OHead = CALCULATE(SUM(CONSOL[NetAbs]),ALLSELECTED(ReportLayout),ReportLayout[Section]="Overhead")
VAR Profit = OpProfit-OHead
VAR LineSum = SUM(CONSOL[NetAbs])+0

VALUES(ReportLayout[Line])="Total Revenue",Revenue,
VALUES(ReportLayout[Line])="Total Operating Cost",OpCost,
VALUES(ReportLayout[Line])="Total Operating Profit",OpProfit,
VALUES(ReportLayout[Line])="Total Overhead",OHead,
VALUES(ReportLayout[Line])="Total Profit",Profit,

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,091 questions
0 comments No comments
{count} votes

Accepted answer
  1. Dave Patrick 426.3K Reputation points MVP

    Power Bi is not currently supported here on Q&A. The product group for Power Bi actively monitors questions over at

    --please don't forget to upvote and 145510-image.png if the reply is helpful--

0 additional answers

Sort by: Most helpful