Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 : -
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 ?
Solved! Go to 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.
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
@push Create this measure,
MEASURE = CALCULATE
( SUM('Table 1'[quantity ])*SUM('Table 1'[net price ]),
FILTER(Table 1, 'Table 1'[brand] = "bagga buggy")
)
Thanks for your effort,
but the total of this measure
will be incorrent
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |