Forum Discussion
Divide function not splitting data as per the expected
Hi Community, Probably the one i am sharing below might be an easier one . However, i am not sure how to search the existing articles or how to fix this issue. I have columns called SVP,Month ye...
Hi Anonymous ,
Based on your description, the easiest way is that you can move the date column in your table visual.
Result:
Or you can modify your "Denominator" column as follows so that you don't have to remove the date column.
Denominator = CALCULATE(COUNT ( 'Mainframe Turndown'[PROCESSNAME] ),ALL('Mainframe Turndown'))Result:Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jaideepnema
Solution Sage
Solution SageHi Anonymous ,
Try changing the denominator measure to :
Total Count of rows = CALCULATE(COUNT ( 'Mainframe Turndown'[PROCESSNAME] ),ALL('Mainframe Turndown'[PROCESSNAME]))
Hope that helps !! 😀
Hi JaiDeep,
I recreated a DAX measure with the code you have given. It didnt helped to resolve the issue.
Not sure what to do now.
​​​​​​