Simple Division Issue - Not so simple

[Anonymous]

Hello everyone,

I'm facing an issue of simple divison for my graphs.

Below on the left you see both values in their own graphs, on the right you see the divison.

Now as you can see the division isn't correct. Take december: 78/166*100%= 46.99%, it displays: 53%.

Code used:

DIVIDE([Value01],[Value02])

Hope someone can help out.

[Anonymous]

Hi,

Try DIVIDE ( [Value01] , [Value02] , 0 )

Regards,

Pavan Vanguri.

[Anonymous]

Hey,

it changed the value for Jan for example, but still not correct:

[Anonymous]

Hi,

Can you please let me know what is Value01 and Value02.

I mean the DAX expression.

[Anonymous]

Hey vanguripavan, the data comes from a server and just gets pulled into a table.

Simple snippet below:

[v-lili6-msft · Accepted solution]

HI, @Anonymous 

If what you had created is a new column, you should create a new measure

Try this formula:

Measure = DIVIDE(SUM('Table'[Value1]),SUM('Table'[Value2]))

If not your case, please share your sample pbix file.

Best Regards,

Lin

[Anonymous]

Amazing, this solved the issue! Had no idea I had to use the measure. 

@v-lili6-msft thanks!

[Anonymous]

Hi,

I think you are not using the SUM aggregratior.

I suggest you to please create calculated measures for Value01 and Value02,
Value01 = SUM(NPSNUMBERS)
Value02 = SUM(CALLSRESOLVED)

And use the above calculated measures for calculate percentages.
DIVIDE ( Value01 , Value02 , 0 ).

I think this will resolves the issue. Please let me know if you still face any issues.

Regards,

Pavan Vanguri.