Forum Discussion
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(...
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.
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
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.
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