Forum Discussion

Minseven's avatar
Minseven
Helper I
7 years ago
Solved

How to not summarize measures

Hi all,   I have 2 tables: MATERIAL and SALES_MVT. I want to have a table that list ALL the material without filtering my table due to my summarized measure.   For better understanding of my iss...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Minseven ,

     

    To update your measure as below.

    QTY_Sold2 = 
VAR _sum =
    CALCULATE (
        SUM ( 'SALES_MVT'[QTY] ),
        FILTER ( SALES_MVT, SALES_MVT[ZONE] = "US" )
    )
RETURN
    IF ( ISBLANK ( _sum ), 0, _sum )

    Or we can anable the option show items with no data.

     

    Regards,

    Frank

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Minseven ,

 

To update your measure as below.

QTY_Sold2 = 
VAR _sum =
    CALCULATE (
        SUM ( 'SALES_MVT'[QTY] ),
        FILTER ( SALES_MVT, SALES_MVT[ZONE] = "US" )
    )
RETURN
    IF ( ISBLANK ( _sum ), 0, _sum )

Or we can anable the option show items with no data.

 

Regards,

Frank

Minseven's avatar
Minseven
Helper I
7 years ago

option SHOW ITEM WITH NO DATA helped me! I completely forgot this option :smileyfrustrated:

 

Thank you