Forum Discussion

push's avatar
push
Frequent Visitor
4 years ago
Solved

DAX related

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 ? 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

3 Replies

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    4 years ago

    push Create this measure,

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

     

    • push's avatar
      push
      Frequent Visitor
      4 years ago

      Thanks for your effort,
      but the total of this measure

      will be incorrent 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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