Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

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...
v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.... 

     

     

     
    • v-yanjiang-msft's avatar
      v-yanjiang-msft
      Icon for Community Support rankCommunity Support
      4 years ago

      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.