DAX fridays! #19: DIVIDE

[@NorbertoVeraReatigaNVR]

Muchas Gracias Ruth!! ya los entusiastas del uso de datos tenemos una excelente videoteca de las funciones DAX y de las características de Power BI, perfectamente ilustradas con buenos ejemplos, brindados generosamente por su canal y CURBAL...

[@CurbalEN]

+Norberto Vera Reatiga Todo un placer poder contribuir a esta comunidad con mis conocimientos. El aprecio y cariño recibido es increíble. :) /Ruth

[@Devloper56]

Perfect !!! I learned a lot from your video, especially DAX!!!! Lots of love from India😊😊😊

[@CurbalEN]

Wonderful to hear!

[@rolandkc]

That's a good alternative, no need to worry about calculation error when dividing.

[@CurbalEN]

+Roland Kc Yes, I always use divide nowadays. By the way, did you get my answer to your messages? /Ruth

[@Unbox747]

Dax Fridays! Love it!

[@CurbalEN]

Thanks :) /Ruth

[@mayraruiz3764]

Hi Ruth, How can I use the divide function where the denominator needs not to be affected by filters in the visualization (slicer) but the numerator does. I have tried the following but is not working: Measure = DIVIDE([numerator],CALCULATE([Denominator],ALL(column])), 0)

[@joanneagius8181]

Hi, how can i divide one column with another (like you showed) and multiply by 1000 in Power Bi?

[@gauravkhurana4807]

Thanks, I wanna divide two different columns, from two different tables?

[@sandeeps6309]

% of two different tables= DIVIDE(SUMX(RELATEDTABLE(tablename),[columnname]),SUMX(RELATEDTABLE('tablename'),[columnname]))

[@kumarakannan1705]

Hi Curbal, I am dividing column B with column A using divide dax function on column C, the divide function is working correctly in each row but in the column C grand total, all the values got sum up instead of dividing grand column B with grand total column A. pls help to fix this.

[@CurbalEN]

Check this video to see if it helps: m.kzbin.info/www/bejne/q5ergIKCmc6SoM0 /Ruth

[@kumarakannan1705]

My problem is different, Consider i have column C it has dax function (Column C = Divide(Column B,Column A,0)). This dax function working correctly in each row but when it comes to grand total of Column C, all values in Column C are summing up. In grand total column i am expecting the values like [Grand Total of Column C= sum(Column B) /sum(Column A)]

[@CurbalEN]

You can modify how the totals are caclulated followlng the example In the video. For personalized help, please ask in the power bi community. /Ruth

[@midsummer4864]

Thank you

[@CurbalEN]

You welcome :) /Ruth

[@peterg4130]

So I thought that the "AlternateResult" could be anything, but apparently not? Only "0" is accepted?

[@CurbalEN]

Mmmm did that a video a long time ago... which minute do I say that? /Ruth

[@peterg4130]

You didn't, I was just trying to enter other values myself and they would not be accepted, but when I typed in '0', it worked.

[@CurbalEN]

Sorry, I read your comment too fast.. They are not very clear in the documentation, but they use “1” as an example: msdn.microsoft.com/en-us/library/jj677276.aspx /Ruth