Can I get the same results if i use a visual and filter certain columns than by using DAX?

[AlanE10]

I just started learning power Bi and this is bothering me. Can I get the same results if i use a visual and filter certain columns than by using DAX? Like, if I were to create a table with categories and the sum of whatever value, wouldnt it be the same and even easier than using calculate to obtain this measure?

I get the feeling it is possible to "bypass" using DAX or M and still get the desired results

[v-zhangti]

Hi, @AlanE10 

As an example.

Measure:

Sum1 = SUM('Table'[Value])

Sum2 = CALCULATE(SUM('Table'[Value]),ALL('Table'))

Filtering views or columns does not give the value of Sum2. Dax will give more possibilities for the calculation.

Best Regards,

Community Support Team _Charlotte

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

[TomMartens · Accepted solution]

Hey @AlanE10 ,

you don't have to use DAX to filter for certain elements. This is exactly what are slicers for.

Select one or more elements in one or more slicers and the table (ideally an related table) will be filtered an the visual automatically aggregates the remaining rows.

Here you will find an introduction to data modeling (creating dimension tables like Calendar, Product, or Customer, and fact tables): https://docs.microsoft.com/en-us/learn/modules/design-model-power-bi/

Hopefully, this provides you with an idea on how to tackle your challenge.

Regards,

Tom