topic Re: Help in DAX Commands and Tips

Help

Nihed — Sat, 19 Feb 2022 00:36:33 GMT

Hello,

please someone can help me on the table display I wanted to put the total online and not in column?

I want to display the total of each quarter.

tackytechtom — Sat, 19 Feb 2022 08:44:29 GMT

First take the matrix visual and drag in the fields accordiingly:

After you can choose which totals you would like to display by using the toggles:

Hope this helps 🙂

Tom

Nihed — Sat, 19 Feb 2022 18:59:34 GMT

Hello ,

Thank you for your return.

Unfortunately, I can’t do it I don’t have this option in the power BI.

tackytechtom — Sat, 19 Feb 2022 19:04:04 GMT

What PBI version do you have? You can find the version under File > About (at the very bottom)

I have this one:

/Tom

Nihed — Sat, 19 Feb 2022 19:10:08 GMT

I have the same version as you

this is what is displayed 😕

tamerj1 — Sat, 19 Feb 2022 21:03:10 GMT

You can update now to the new version. I just updated mine yesterday

Icey — Tue, 22 Feb 2022 03:22:25 GMT

You can get the same format pane by enable the "New format pane" preview feature and then you can find the same options like tackytechtom.

And for the format pane you are using currently, you can find that option here:

And based on your screenshots, I guess you are using the feature of "Show on rows". Right?

If so, the simplest method is to create total measure manually like so:

Measure Total = [Measure 1] + [Measure 2]

Best Regards,

Icey

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