Measure

[Anonymous]

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

[v-yiruan-msft · Accepted solution]

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.

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

[v-yiruan-msft · Accepted solution]

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.

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

[amitchandak]

@Anonymous , Does the above solution helped you.

[v-yiruan-msft · Accepted solution]

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.

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

[Greg_Deckler]

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