Measure calculation divide function not work

x0 — Thu, 21 Mar 2024 09:53:10 GMT

Hello Everyone ,

I have created 3 simple measure , unfortunatley from 3 of 2 is working and 1 is not work well anyone have any suggestion ?

here i am sharing 3 measure . with that i also share what my need , you may also refer me if something difrent method for achive my aim

1st measure

Total Name Count =

CALCULATE(

COUNTROWS('Move Insq'),

'Move Insq'[MonthIndex] IN VALUES('CustomTable'[MonthIndex]),

'Move Insq'[Year] IN VALUES('CustomTable'[Year]),

'Move Insq'[Property] IN VALUES('CustomTable'[Property]),

'Move Insq'[First Name] <> BLANK()

)

this measure count row each names and i used this on my matrix visueal value for see each employee count , which very well working

2nd measure is

Total Move insq percent =

VAR NumMonthsSelected = COUNTROWS(VALUES('CustomTable'[MonthIndex]))

VAR MoveInsWithCustomData =

FILTER(

'Move Insq',

'Move Insq'[MonthIndex] IN VALUES('CustomTable'[MonthIndex]) &&

'Move Insq'[Year] IN VALUES('CustomTable'[Year]) &&

'Move Insq'[Property] IN VALUES('CustomTable'[Property]) &&

'Move Insq'[First Name] <> BLANK()

)

RETURN

DIVIDE(

COUNTROWS(MoveInsWithCustomData),

NumMonthsSelected,

0 -- Specify the value to return if the denominator is zero

)

this measure i used on advance 123 card for see total row and its also working well. show me correct value

now 3rd measure is this

NameCountRatio =

DIVIDE(

[Total Name Count],

[Total Move insq percent],

BLANK()

)

with this measure i want to do divide name count value / with total move insq percent value count

this measure is trouble for me because its returning 100 % for all row .

might be total name count measure and total percent count doing same calculation on first part which is count row then i add do divide with selected month on total move ins1

i need to fix this any how i am too much tired playing arround in this smaller thing

i all share screen shots for better understand

Re: Measure calculation divide function not work

Anonymous — Fri, 22 Mar 2024 08:46:38 GMT

Hi x0 ,

Create a measure that outputs the numerator and denominator separately.

DebugNameCountRatio = "Numerator: " & FORMAT([Total Name Count], "General Number") & ", Denominator: " & FORMAT([Total Move insq percent], "General Number")

Drag and drop the DebugNameCountRatio onto the card visual object on the report page to display it, to determine if the numerator and denominator are the same.

I also did some testing, maybe that helps:

I have the following DAX expressions, the first three are measures and the last two are calculated columns.

Measure = SUM('Table'[value]) Measure 2 = DIVIDE(MAX('Table'[value]),SUM('Table'[value])) Measure 3 = DIVIDE(MAX('Table'[value]),[Measure]) Column = DIVIDE('Table'[value],[Measure]) Column 2 = DIVIDE('Table'[value],SUM('Table'[value]))

Only Column2 is calculated correctly.

You can try replacing measure with calculated column and do not include measures in the calculated columns, and you can copy the logic of measures to the parameter part of the DIVIDE function.

I would be grateful if you could provide me with sample data for testing, please remove any sensitive data in advance.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

topic Measure calculation divide function not work in DAX Commands and Tips

Measure calculation divide function not work

Re: Measure calculation divide function not work