Reply
avatar user
Anonymous
Not applicable

Measure

Hi Experts,

 

i create a pie chart based on count(aa) by Dim_table type X and Y. how can i subtract the  Y value from X value. i need the formula

2 ACCEPTED SOLUTIONS
v-yiruan-msft
Community Support
Community Support

Hi @Anonymous,

You may need to provide more details in order to solve your problem… Could you please provide the fields (X , Y ) information you applied to pie chart (include data type , from which table , some sample data exclude sensitive data )? Please provide one screenshot just like below screenshot.

pie chart.jpg

In additional, what is your expected result ? Whether you want to write one measure to get the value of field X minus field Y ?

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-yiruan-msft
Community Support
Community Support

Hi @San1979

You may need to provide more details in order to solve your problem… Could you please provide the fields (X , Y ) information you applied to pie chart (include data type , from which table , some sample data exclude sensitive data )? Please provide one screenshot just like below screenshot.

aa.JPG

In additional, what is your expected result ? Whether you want to write one measure to get the value of field X minus field Y ?

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-yiruan-msft
Community Support
Community Support

Hi @San1979

You may need to provide more details in order to solve your problem… Could you please provide the fields (X , Y ) information you applied to pie chart (include data type , from which table , some sample data exclude sensitive data )? Please provide one screenshot just like below screenshot.

aa.JPG

In additional, what is your expected result ? Whether you want to write one measure to get the value of field X minus field Y ?

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super User

@Anonymous , Does the above solution helped you.

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
v-yiruan-msft
Community Support
Community Support

Hi @Anonymous,

You may need to provide more details in order to solve your problem… Could you please provide the fields (X , Y ) information you applied to pie chart (include data type , from which table , some sample data exclude sensitive data )? Please provide one screenshot just like below screenshot.

pie chart.jpg

In additional, what is your expected result ? Whether you want to write one measure to get the value of field X minus field Y ?

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler
Super User
Super User

Not enough to go on. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)