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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
poojasanas
New Member

I have created a measure TotalProfit but it's value is not displaying in Visual

I have created a measure  TotalProfit = SUM(Sales[Profit_per_Item])

and on visual selected data card and then selected TotalProfit measure

but it is displaying blank

Kindly help me in this!!

poojasanas_0-1714374677336.png

 

poojasanas_1-1714374703762.png

 

2 REPLIES 2
v-junyant-msft
Community Support
Community Support

Hi @poojasanas ,

@Uzi2019 Thanks for your concern about this case!

After my test, I cannot reproduce the situation you are facing. I've tested using measure values to sum calculated columns in various situations, but in all cases the values were displayed.
Please provide the DAX used for the calculated column. If the DAX involves other tables, please provide the relationship between the two tables and sample data. Thank you!

Best Regards,
Dino Tao

Uzi2019
Super User
Super User

Hi @poojasanas 

You have taken Measure value from calculated column value. [Profit_per_Item]. 
Try to take that valaue. or you can specify what result you are tryin to get through Profit_per_Item and TotalProfit.

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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