Forum Discussion

UncleLewis's avatar
UncleLewis
Responsive Resident
4 years ago

Cannot Add Meausre To Visual

Hi all,   Using PBIDS 2.97 Sept, 2021. I created a measure to get Total Sales By Profit Center - no errors in Meausre However when I try to add it to a visual, I get an error:   Error Message: ...
Need Help
v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi UncleLewis 

Thanks for reaching out to us.

 

Have you solved your problem with the above answers? 

If not, could you share the code of [Total Sales]? This error usually occurs when you make a bool judgment on the value of text type.

Or try this,

Total Sales By Store =
CALCULATE ( SUM ( Sales[Sales] ), ALLEXCEPT ( Sales, Sales[Profit_Center] ) )

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly