topic Re: Comparing Measure with two Dynamic Dates in Matrix - Total not showing in DAX Commands and Tips

Comparing Measure with two Dynamic Dates in Matrix - Total not showing

Anonymous — Wed, 18 May 2022 09:45:30 GMT

Hi,

I have the following situation:

I want to compare the turnover with two dynamic slicers, i.e. I have 2 slicers that each specify a date.
Slicer 1 refers to SALES ACT REL, and slicer 2 to SALES ACT.

The data model looks like this:

Then I calculate in the column "NEW" whether there is a value in SALES ACT and not in SALES REL, which means that this turnover was newly generated.

This calculation also works, but it does not show me the total. I know the problem with the missing total and have tried to work around it by calculating the table with SUMX, but it does not show me a total.

What am I doing wrong? I have tried all possible combinations with SUMX and creating virtual tables, so far without success.
Is there a potential problem with the two dynamic time slicers?

Thanks for your help!

Re: Comparing Measure with two Dynamic Dates in Matrix - Total not showing

v-yanjiang-msft — Mon, 23 May 2022 08:49:52 GMT

Hi Anonymous ,

According to your description, I guess the total row is also in the range of HASONEFILTER(V_FACT_SALES[KDNR_ARTNR], you can modify the formula like this to check it:

RETURN IF( HASONEFILTER(V_FACT_SALES[KDNR_ARTNR],1,0)

If it return 1 in the total row, it means that this is the problem.

Then try to modify the return part of the formula like this:

RETURN SUMX(tab,[DIFF])

Best Regards,
Community Support Team _ kalyj

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

Re: Comparing Measure with two Dynamic Dates in Matrix - Total not showing

Anonymous — Mon, 23 May 2022 13:11:20 GMT

Thanks for your response, I've changed "NEW SUMX" to your formula

RETURN
IF( HASONEFILTER(V_FACT_SALES[KDNR_ARTNR],1,0)

However, in the total column is a "0" displayed, so the TOTAL Column has no KDNR_ARTNR Filter....

Re: Comparing Measure with two Dynamic Dates in Matrix - Total not showing

v-yanjiang-msft — Tue, 24 May 2022 08:28:28 GMT

Hi Anonymous ,

If this is not the case, then try to modify the tab table in the formula, add related columns in the summarized table.

VAR tab= SUMMARIZE( V_FACT_SALES, V_FACT_SALES[KDNR_ARTNR], V_FACT_SALES[NETTOUMSATZ], V_FACT_SALES[SZENARIO] )

Best Regards,
Community Support Team _ kalyj

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