Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello!

So I got it to work! However for some reason it does not with my date slice

TESTING CONVERSION METRIC = 
DIVIDE(
    CALCULATE(
        SUM('Table'[AllIn]),
        ALLEXCEPT('Table',
        'Table'[Milestone])
    ),
    CALCULATE(
        'Table'[Leads],
        ALLEXCEPT('Table', 'Table'[Milestone]),
        ALL('Table'[Milestone]
    )))
Manoj_Nair's avatar
Manoj_Nair
Solution Supplier
3 years ago

Anonymous- Try this one.

 

 

TESTING CONVERSION METRIC = 
VAR SelectedDate = MAX('Table'[Date])   // Get the selected date from the slicer
RETURN
DIVIDE(
    CALCULATE(
        SUM('Table'[AllIn]),
        ALLEXCEPT('Table', 'Table'[Milestone]),
        'Table'[Date] = SelectedDate   // Apply the selected date filter
    ),
    CALCULATE(
        'Table'[Leads],
        ALLEXCEPT('Table', 'Table'[Milestone]),
        'Table'[Date] = SelectedDate,   // Apply the selected date filter
        ALL('Table'[Milestone])
    )
)

 

I updated the measure. Uses the MAX function to retrieve the selected date from the slicer and assigns it to the variable SelectedDate. Then, in both CALCULATE functions, the condition 'Table'[Date] = SelectedDate is added to filter the data based on the selected date.