Forum Discussion

x0's avatar
x0
Icon for Helper I rankHelper I
2 years ago

divide 2 measure internal

Hello All ,   I have created 2 measure which is as per this  1 is  Total Names Count Divided by 3 = VAR SelectedMonths = VALUES('CustomTable'[MonthIndex]) VAR SelectedYears = VALUES('CustomTab...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi x0 ,

 

Based on the formula you provided, it looks like you want to divide the first measurement by the second measurement. I have tried the following modification, please refer to it:

Total Move insq percent =
VAR LeasingAgentsWithCustomData =
    FILTER (
        'Move Insq',
        'Move Insq'[MonthIndex]
            IN VALUES ( 'CustomTable'[MonthIndex] )
                && 'Move Insq'[YearPart]
                    IN VALUES ( 'CustomTable'[Year] )
                        && 'Move Insq'[Property]
                            IN VALUES ( 'CustomTable'[Property] )
                                && 'Move Insq'[First Name] <> BLANK ()
    )
RETURN
    DIVIDE ( COUNTROWS ( LeasingAgentsWithCustomData ), COUNTROWS ( 'Move Insq' ) )

Total Names Count Divided by 3 =
VAR SelectedMonths =
    VALUES ( 'CustomTable'[MonthIndex] )
VAR SelectedYears =
    VALUES ( 'CustomTable'[Year] )
VAR SelectedProperties =
    VALUES ( 'CustomTable'[Property] )
RETURN
    DIVIDE (
        COUNTROWS (
            FILTER (
                'Move Insq',
                'Move Insq'[MonthIndex]
                    IN SelectedMonths
                        && 'Move Insq'[YearPart]
                            IN SelectedYears
                                && 'Move Insq'[Property]
                                    IN SelectedProperties
                                        && 'Move Insq'[First Name] <> BLANK ()
            )
        ),
        3
    )

Final Measure1 = 
DIVIDE(
    [Total Names Count Divided by 3],
    [Total Move insq percent]
)

 

Best Regards,
Adamk Kong

 

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

 

x0's avatar
x0
Icon for Helper I rankHelper I
2 years ago

Hello Anonymous 

 

seems like your provided solution work for me 

but i need some modification 

lets look this measure first 

Total Names Count Divided by 3 =
VAR SelectedMonths =
    VALUES ( 'CustomTable'[MonthIndex] )
VAR SelectedYears =
    VALUES ( 'CustomTable'[Year] )
VAR SelectedProperties =
    VALUES ( 'CustomTable'[Property] )
RETURN
    DIVIDE (
        COUNTROWS (
            FILTER (
                'Move Insq',
                'Move Insq'[MonthIndex]
                    IN SelectedMonths
                        && 'Move Insq'[YearPart]
                            IN SelectedYears
                                && 'Move Insq'[Property]
                                    IN SelectedProperties
                                        && 'Move Insq'[First Name] <> BLANK ()
            )
        ),
        3
    )

on this i dont want to divide with 3 i just want when i select multiple divide with that select month for example i selected only 8 month 2023 measure should divide with 1 and if selecte 8+9 2023 should be divide with 2 

 

now same thing i want for this measure 

Total Move insq percent =
VAR LeasingAgentsWithCustomData =
    FILTER (
        'Move Insq',
        'Move Insq'[MonthIndex]
            IN VALUES ( 'CustomTable'[MonthIndex] )
                && 'Move Insq'[YearPart]
                    IN VALUES ( 'CustomTable'[Year] )
                        && 'Move Insq'[Property]
                            IN VALUES ( 'CustomTable'[Property] )
                                && 'Move Insq'[First Name] <> BLANK ()
    )
RETURN
    DIVIDE ( COUNTROWS ( LeasingAgentsWithCustomData ), COUNTROWS ( 'Move Insq' ) )

 same as per first and the final measure should perfororm 

Final Measure1 = 
DIVIDE(
    [Total Names Count Divided by 3],
    [Total Move insq percent]
)