DAX related

[push]

hello guys, 
i am new in power bi  and i am facing some issues in DAX (CALCULATE()  FUNCTION).

i had created one measure with the following dax query : -

sales =

    CALCULATE(

        SUMX(

        'Table 1',

        'Table 1'[quantity ]*'Table 1'[net price ]

    ),

     'Table 1'[brand] = "bagga buggy"

    )
i am getting this output : - 

so the issue is this : - 
when i am adding year column in my visualization the data is also filtered out through YEAR in addition with "table 1"[brand] = "bagga buggy"  (which i had mentioned in above dax query).

Since  "table 1"[brand] = "bagga buggy" Internally this should work like this "FILTER(ALL('TABLE 1'),'table 1'[brand] = "bagga buggy" ) " 

WITH "table 1"[brand] = "bagga buggy"                                        

  WITH  "FILTER(ALL('TABLE 1'),'table 1'[brand] = "bagga buggy" )" 

CAN ANY ONE HELP ? 

[Anonymous · Accepted solution]

Hi  @push ,

Whether the "the total of this measure" you mean is a yellow label for the image:

Here are the steps you can follow：

1. Create measure.

Total =
var _table=SUMMARIZE('Table','Table'[Group],"Value",[Measure])
return
IF(
    HASONEVALUE('Table'[Group]),[Measure],SUMX(_table,[Value]))

2. Result:

If you need pbix, please click here.

DAX related.pbix

Best Regards,

Liu Yang

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

[Tahreem24]

@push Create this measure,

MEASURE = CALCULATE
                         (  SUM('Table 1'[quantity ])*SUM('Table 1'[net price ]),
                           FILTER(Table 1, 'Table 1'[brand] = "bagga buggy")
                          )

[push]

Thanks for your effort,
but the total of this measure

will be incorrent