Wrong totals when calculating percentages (not possible with functions)

[ROG]

Hi all,

How can I have the correct total on my table below. I have read several similar questions about it in here, but all of them were solved using either HASONEVALUE or HASONEFILTER, but as you see below, my mesure is created on top of other metrics, and I'm unable to use this functions.
I know measure won't display the sum of the values in the column, but could you please help me with that?

Net Churn - 30D% YTD Var = [Net Churn - 30D% YTD] - [Net Churn - 30D% LYTD]

Thank you.

[tamerj1]

Hi @ROG 

what are you slicing by in this table?

[ROG]

Hi @tamerj1 

I'm using two different dimentions: Tenure and Customer Category
How should I use them on the calculation?

[tamerj1]

Hi @ROG 
Please try

Net Churn - 30D% YTD Var =
SUMX (
    CROSSJOIN ( VALUES ( 'Table'[Tenure] ), VALUES ( Customer[Category] ) ),
    [Net Churn - 30D% YTD] - [Net Churn - 30D% LYTD]
)

[ROG]

Hi @tamerj1  With the measure you provided is giving the not expected total. Even the rows are very different. 

[tamerj1]

@ROG 

Of these are the only columns in this table visual then it should work. Can you please share w screenshot of the dax code you've used?

[ROG]

Of course @tamerj1 

Net Churn - 30D% YTD Var_new =

SUMX (

    CROSSJOIN ( VALUES ( 'Tenure Band'[Tenure Band]),VALUES ( 'Tenure Band'[Tenure Flag]), VALUES ( 'Tenure Band'[Tenure FlagB]),VALUES ( 'Customer Category'[Customer Category Name]) ),

    [Net Churn - 30D% YTD] - [Net Churn - 30D% LYTD]

)

[tamerj1]

@ROG 

Please try

Net Churn - 30D% YTD Var_new =
SUMX (
CROSSJOIN (
SUMMARIZE (
'Tenure Band',
'Tenure Band'[Tenure Band],
'Tenure Band'[Tenure Flag],
'Tenure Band'[Tenure FlagB]
),
VALUES ( 'Customer Category'[Customer Category Name] )
),
[Net Churn - 30D% YTD] - [Net Churn - 30D% LYTD]
)

otherwise please share a screenshot of your data model with the relationships