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...
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)
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.
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)]
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
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...
+Norberto Vera Reatiga Todo un placer poder contribuir a esta comunidad con mis conocimientos. El aprecio y cariño recibido es increíble. :)
/Ruth
Perfect !!! I learned a lot from your video, especially DAX!!!! Lots of love from India😊😊😊
Wonderful to hear!
That's a good alternative, no need to worry about calculation error when dividing.
+Roland Kc Yes, I always use divide nowadays.
By the way, did you get my answer to your messages?
/Ruth
Dax Fridays! Love it!
Thanks :)
/Ruth
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)
Hi, how can i divide one column with another (like you showed) and multiply by 1000 in Power Bi?
Thank you
You welcome :)
/Ruth
Thanks, I wanna divide two different columns, from two different tables?
% of two different tables= DIVIDE(SUMX(RELATEDTABLE(tablename),[columnname]),SUMX(RELATEDTABLE('tablename'),[columnname]))
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.
Check this video to see if it helps:
m.th-cam.com/video/ufHOOLdi_jk/w-d-xo.html
/Ruth
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)]
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
So I thought that the "AlternateResult" could be anything, but apparently not? Only "0" is accepted?
Mmmm did that a video a long time ago... which minute do I say that?
/Ruth
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.
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