Forum Discussion
infantpowerbi
Helper II
7 years agoRequired two measure’s value across an axis in Line Chart based on slicer
Dear All, I am new and infant to power bi and facing lot of challanges for moving Tableau reports to Power BI And below is the sample data format which is in my oracle db Company Q2 FY 2018 ...
v-piga-msft
Resident Rockstar
7 years agoHi infantpowerbi ,
From your sample, I found that your error is casued by the dax highlighed below.
All =
CALCULATE (
SUM ( 'Ratifications_Table'[District Short] ),
FILTER (
ALL ( Ratifications_Table[District Short] ),
'Ratifications_Table'[District Short] = "ALL"
)
)
As your Ratifications_Table[District Short] column is a string type, so it cannot be usefd with sum function so you will have error message.
I'm afraid that you should create the measure like below.
All_ =
CALCULATE (
SUM ( 'Ratifications_Table'[Value] ),
FILTER (
ALLSELECTED ( Ratifications_Table ),
'Ratifications_Table'[District Short] = "ALL Districts"
)
)
Best Regards,
Cherry
infantpowerbi
Helper II
7 years agoDoes Sum can be only applied for decimal numbers ?
Because I a trying to make it for % columns ,But finding no luck.Kindly please look into % column "AppSubmission"