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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
chavanr
Resolver I
Resolver I

Measure to calculate total in Bar Cluster chart

Hi there,

 

I am trying to calculate total for a Cluster Bar chart, but it is giving me the following error

chavanr_0-1627957244685.png

 

I have created a Table :

ChartAxis = UNION(VALUES('WDC StreetWise'[Service]), ROW( "Service", "All"))
 
And the measure for the same:
HHByService =
VAR A = MAX(ChartAxis[Service])
RETURN
IF(A<> "ALL",
CALCULATE(
SUM('WDC StreetWise'[Custom]),'WDC StreetWise'[Service] =A),
CALCULATE(SUM('WDC StreetWise'[Custom]),ALLSELECTED('WDC StreetWise')
)
)
 
 
 

 

 

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@chavanr 

the error looks like you are using the sum function on a text column. maybe try to change the data type to number?

if not, pls provide the sample data and expected output





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
ryan_mayu
Super User
Super User

@chavanr 

the error looks like you are using the sum function on a text column. maybe try to change the data type to number?

if not, pls provide the sample data and expected output





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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